Hi

Select * into <TableName> from <TableName> Where 1=0
this will do.

VJ
----- Original Message -----
From: "Shibu MB" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, November 21, 2002 5:27 PM
Subject: copy of table


Hi all

How can i create a copy of an existing table with different name .?
Like "create table < new tablename > as select * from emp where 1 = 0
"
in oralce what is the corresponding query in sqlserver ?

Thanks
Shibu


MS Sql Server LazyDBA home page