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

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

897

What is a node in teradata? Explain

1050

What is the difference between fastload and multiload?

1458

Explain teradata vs. Redshift?

1076

What type of indexing mechanism do we need to use for a typical data warehouse?

1222

What are the things to be considered while creating secondary index?

1140

Which is more efficient group by or distinct to find duplicates?

1126

What is called partitioned primary index (ppi)?

1053

Explain BYNET.

1051

How you will check the version of teradata?

1220

What is the purpose of indexes?

1126

How to view every column and the columns contained in indexes in teradata?

1095

How to run a query in teradata?

1141

What is the syntax for case when statement?

1212

What are the frequently used data types in teradata?

1130