[thelist] [tip] duplicate a table structure

[rudy]

> If you need a quick way to duplicate a table structure in SQL Server 
> and can't get into EM, you can use the following SQL:

or this --

   SELECT *
    INTO newtable
    FROM oldtable
      where 1=0

no subsequent truncate required

who uses EM for this type of stuff anyway?   QA rulez!!


rudy