4th Jun 2014

Copy table schema to new a table

In SQL Server, SELECT INTO is used to copy data from an existing table/s into a new one.

However by adding a WHERE clause which will always return false, this will prevent any data from being copied, and therefore create an empty copy of the table schema into a new table.

For example if we have a table, "TableA", the schema of this table can be copied into a new table, "TableB", by executing the following:

SELECT *
INTO TableB
FROM TableA
WHERE 1=0