[thelist] [tip] duplicate a table structure

rudy rudy937 at rogers.com
Sun Oct 12 22:12:33 CDT 2003

> 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 --

    INTO newtable
    FROM oldtable
      where 1=0

no subsequent truncate required

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


More information about the thelist mailing list