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 oltp?

If a Node is busy what are the steps you can take to avoid ?

IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.

Can any one plz provide the teradata interview questions?

What do you mean by tpt in teradata?

What are default access rights in teradata?

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

Where is teradata rdbms used?

What is teradata? What are some primary characteristics of teradata?

what are the roles and responsibilities of teradata DBA ?

What interface is used to connect to windows based applications?

what is use of fload loading into set table?

For more Teradata Interview Questions Click Here