Creating a replica sql table

Question

I need a query to create a table that is an exact replica, but with a different table name and without any data from the original table using an SQL query!

Answer 1

You can try this

SELECT * INTO Table_Copy
FROM Table
where 1=2

It will create an empty table with the same structure.

Answer 2

Jonathan has this (upvoted), and you should probably go for it because it's more portable. I usually use something like this:

SELECT TOP 0 * INTO [New_Table] FROM [Old_Table]

I think this better expresses what you are doing, but I like Jonathan because "TOP 0" is SQL Server and therefore it is more portable.

Answer 3

• SQL Server
• →
• →
• Script → →

Answer 4

MySQL SHOW CREATE TABLE table_name;

CREATE TABLE. , .

http://dev.mysql.com/doc/refman/5.1/en/show-create-table.html

Answer 5

Postgresql:

CREATE TABLE LIKE table_name

http://www.postgresql.org/docs/8.1/static/sql-createtable.html

Answer 6

SELECT * INTO Table_Copy
FROM Table
where 1=2

, - .

SELECT * INTO Table_Copy
FROM Table

.

Answer 7

:

CREATE TABLE foo AS SELECT...

Answer 8

select * into newtablename from sourcetablename
go
truncate newtablename
go

, , truncate.

Answer 9

create table <new table name> as select * from <old tale name from which you would like to extract data>

, .

Answer 10

postgres INHERITS LIKE ( )

CREATE TABLE client_new ( LIKE);

CREATE TABLE client_new() INHERITS ()

INHERITS . () , (). LIKE , , . INHERITS, . , .