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