dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Quickest Way to Copy the Structure of a Table

This quick tip demonstrates how to copy a table's data, as well as only the structure of a table.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


A very common task is to backup a table's data, but sometimes we'd just like to copy a table's structure. This quick tip will demonstrate how to copy a table's data as well as only the structure of a table.

To copy a table along with its data, use the following query:

SELECT * INTO COPYofTABLE
FROM TABLEtoCOPY

The above query creates a table and copies the data from the TABLEtoCOPY table into the COPYofTABLE table.

To copy only the table structure, use a query similar to the following query:

SELECT * INTO COPYofTABLE
FROM TABLEtoCOPY
WHERE 1 = 2

This query creates only the table structure and does not copy any data. Why? The answer lies in the WHERE clause. Because 1 will never equal 2, there will be no results to copy, thus only creating the empty table structure inside the new table.

 

Visit the DevX Tip Bank

 





   
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date