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

836

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1776

Explain the parallel data extension in teradata?

1095

What is the use of fallback?

996

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1153

Explain the types of join supports by teradata?

995

Explain fastload in teradata?

1104

What is primary index and secondary index?

1028

What is smp and mpp platforms?

971

Explain the most common data types used in teradata?

1072

What are the string manipulation operators and functions associated with teradata?

1090

What is meant by a Virtual Disk?

1136

Difference between multiload and tpump?

1104

What are the frequently used data types in teradata?

1083

What is the syntax for case when statement?

1143