Create table tablename as existing tablename with (no) data

How do you create a table with an existing structure of another table with data and with no data?

Question Posted / praveen kota

Answer Posted / praveen kota

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2361

What are the advantages of teradata?

955

In BTEQ, how are the session-mode parameters being set?

1086

How will you solve the problem that occurs during update?

983

What are differences between teradata and ansi session modes in teradata?

1093

Explain parsing engine in teradata?

1021

Why does varchar occupy 2 extra bytes?

1102

Differentiate primary key and partition key?

934

Explain teradata architecture?

1026

What are the frequently used data types in teradata?

1001

How do you define Teradata?

981

How can we check the version of Teradata that we are using currently?

1012

How do you determine the number of sessions?

1007

how can we analyze the locks ?

2058

What are the different table types supported by teradata?

891