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

Mass wireless technics sl-b210 turntable of mass

Hello, i have a problem, my phone displays register.

Google has disappeared

Ssd in an acer predator helios neo 18 ai pnh 18-72

Sync my emails on my pc from iphone 17 with outlook

Get rid of the back button gear sport

Question about gmail

Excel file bug

Texture issues in enshrouded

Pc that keeps crashing in a loop