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

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

Question Posted / amarjit kumar

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

Answer / praveen kota

Create table tablename as existing tablename with (no) data

Is This Answer Correct ?

0 Yes

0 No

More Teradata Interview Questions

What is dimensional modeling?

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

What is meant by a Virtual Disk?

Explain teradata architecture?

What is the meaning of Caching in Teradata?

where we can use the delimiter in mload? pls let me know

What is a level of granularity of a fact table?

Why FLOAD does not support multiset tables??

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

Explain the term 'primary key' related to relational database management system?

What are the primary characteristics of the Teradata.

What is meant by a Highest Cost Plan?

For more Teradata Interview Questions Click Here