How do you create a table with an existing structure of another table with data and with no data?



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

Post New Answer

More Teradata Interview Questions

What is the primary index in teradata?

0 Answers  


Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 Answers  


Explain how spool space is used.

0 Answers  


How do you define Teradata?

0 Answers  


What are the components provided on node?

0 Answers  






Syntax for case when statement?

0 Answers  


What are types of partition primary index (ppi) in teradata?

0 Answers  


what are the file sizes in your project?

2 Answers  


Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE

2 Answers   IBM,


How you will check the version of teradata?

0 Answers  


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

0 Answers  


What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,


Categories