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

What is your experience with android tablets abor

Disable office

Comaps on play store

I would like to know how to report a scam

Reinstallation of w11 impossible after pc crash...

Site unreachable

Nonexistent sent items folder

Transfer mp3 from pc to mobile

Increase the capacity of free's zimbra webmail to 10gb

Unrefreshed usb drive on android interface