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

If the script is aborted. why it is aborted and how can you identify ?

What happens in a conflict? How do you handle that?

what is identity columns in TD?

any one pls tell me what are the table names in banking project?

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

what is use of fload loading into set table?

Does SDLC changes when you use Teradata instead of Oracle?

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

Explain teradata utilities?

what are the day to day activities of teradata DBA ?

What do you mean by tpt in teradata?

What are default access rights in teradata?

For more Teradata Interview Questions Click Here