Create clone copy of table without data in SQL Server

You could add WHERE 1=2 to get structure only:

Select * 
into Clone_Supplier 
from Supplier
where 1=2;

It won't be exact copy though:

• no constraints
• no indexes
• no triggers

Copy all columns from selected table

Select Top 0 * into NewTable from OldTable

Copy some columns from selected table

Select Top 0 Col1,Col2 into NewTable from OldTable

Copy all(Data and Structure)

Select * into NewTable from OldTable