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

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


Please Help Members By Posting Answers For Below Questions

Explain the advantages of partitioned primary index in a query?

805


What are the functions involved in shared information architecture?

857


What is meant by Teradata Gateway?

856


What is multi insert?

833


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

778


Explain the teradata primary index mechanics in detail with a diagram.

784


What is the difference between teradata and basic rdbms?

787


In BTEQ, how are the session-mode parameters being set?

944


Define views in teradata with general syntax.

823


Explain PDE.

867


What are the advantages of teradata?

821


What is a node in teradata? Explain

813


Explain Teradata performance tuning and optimization?

953


Explain BYNET.

812


How to identify ppi columns?

916