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

What does Amp contain and what are all the operations that it performs?

995

What is node? How many nodes and amps used in your previous project?

1106

What are the joins in teradata?

982

What is the syntax for case when statement?

1128

During the Display time, how is the sequence generated by Teradata?

1049

Explain how spool space is used.

1070

How to eliminate product joins in a teradata sql query?

1014

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1233

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

985

Can you connect multiload from ab initio?

1207

Explain BYNET.

988

Explain the term 'tables' related to relational database management system?

1039

if collect stats but it show low confidence why?

1679

What is meant by a Highest Cost Plan?

1055

Describe the between keyword in teradata?

1030