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

how teradata fetches a row from primary index table?

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

What is collect State in Teradata ? what it use and how it works??

Explain fastload in teradata?

What is meant by MATCHTAG in multiload utility?

List out teradata data types?

Why are oltp database designs not generally a good idea for a data warehouse?

How is MLOAD Teradata Server restarted after execution?

What are the joins in teradata?

How will you solve the problem that occurs during update?

What is difference between user and database in teradata?

what is single value and Multivalue ?

For more Teradata Interview Questions Click Here