How do you create a table with an existing structure of another table with data and with no data?
- 1 Answers
- 889 Views
- I also Faced
- E-Mail Answers
Answer Posted / praveen kota
Create table tablename as existing tablename with (no) data
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate primary key and partition key?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is the difference between global temporary tables and volatile temporary tables?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is a three-tier data warehouse?
What is logical data model?
What is multi insert?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Explain teradata utilities. What is multiload, fast load, tpump?
Which is faster fastload or multiload?
What is oltp?
When tpump is used instead of multiload?
Describe the between keyword in teradata?
Explain how spool space is used.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
