Joshua wrote: > 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: > > SELECT TOP 1 * > INTO newtable > FROM oldtable > > TRUNCATE TABLE newtable or just... SELECT TOP 0 * INTO newtable FROM oldtable and save yourself a step! Paul