SQL: copy a table into another... Solved

Question

Hello everyone,

The query:
CREATE TABLE TABLE2 AS SELECT * FROM TABLE1 ;
allows me to copy the structure as well as the data from TABLE1 into TABLE2.
Is there a way (query) to copy only the structure (without the data)?

Thank you all for your help.

Lio · Accepted Answer

Even cleaner:  CREATE TABLE table2 LIKE table1  (Simply copies the structure of table1 by creating table2)

yanban · Answer

if :  CREATE TABLE TABLE2 AS SELECT * FROM TABLE1 where 1=2

Nico · Answer

Awesome... Thanks yanban.

drizzt40 · Answer

It's funny, I was thinking of creating the structure with the data and then deleting the content of the table.... We need to learn to simplify our lives..... ;)  =}- The_Str@nger -{=

doanvhay · Answer

Hello,  Once the empty table2 is created, how can it be copied to give it to a third party?

nubian110 · Answer

Thank you very much, it's beautiful, "Simplicity is an art"!!!

Syls · Answer

Hello,  the where clause just returns a bool.  So, something like:  SELECT * INTO TABLE2 FROM TABLE1 WHERE 1=0  should "create" the structure without returning any data.  Syls

Syls · Answer

Even a little cleaner:  SELECT * INTO TABLE2 FROM TABLE1 WHERE FALSE

Noum77 · Answer

I have this for the structure only; but you'll need to try it because I haven't had the time yet:  CREATE TABLE table1_copy LIKE mabase.table1;

SQL: copy a table into another...

9 answers

My old netlog account

White screen but the commands work fmc-j5335dw

Very slow startup.

Vmc: the error that promotes humidity and mold

Printer ink absorber almost full on canon pixma mg5750

Occt paid??

Persistent printing issue with my printer

Lost sim card

Canon ts3351 printer

Remove personal information from edecideur.com