How to create a copy of a Table Structure in SQL Server

To create a table that has the same structure as the originated table, but without data in it, use the following query (in this example we create a dbo.Copy_of_Product_Table_Structure table based on the structure of Production.Product table):

SELECT TOP 0 * INTO dbo.Copy_of_Product_Table_Structure
FROM Production.Product

To check if any data is copied to the new table:

SELECT * FROM dbo.Copy_of_Product_Table_Structure

select_from_copy_of_table_structure

The newly created table has the same structure as the originated table, but data, indexes, keys and constraints are not copied to the new table, as you can see in the table design:

Originated table design:

design_originated_table

Copied table design:

design_copied_table

Read related articles:

How to insert data from one table to another in SQL Server

How to create a copy of a Table using SELECT INTO in SQL Server