create table dest-tablename
as
select * from source-tablename where 1=2
SELECT * into dest-tablename from source-tablename where 0=1
select top 0 * into dest_table from source_table
create table dest-tablename
as
select * from source-tablename where 1=2
SELECT * into dest-tablename from source-tablename where 0=1
select top 0 * into dest_table from source_table