ramakrishnasri

 Profile Answers by ramakrishnasri 

• Dec 6th, 2007

 

hai,

here is the example for ypour qustion

select * into emp1 from emp where 1=9


execute this u can have the structure of the new table as old with out the data in the new table


i hope it will solve your problem

rudatha

 Profile Answers by rudatha 

• Apr 23rd, 2008

 

select * into new table name from old table name where 1=0