duplicating a table in SQL server 1

[Guest_imported]

Hi,

What's the quickest way to duplicate a table in Microsoft SQL 7.0.

Can you duplicate the structure and the data

or

just the structure

cheers

Mark

 

[xcata]

DTS for structure and data and generate script, change table name, execution of new script if you want only to duplicate the structure.

 

[Tim1]

Hi Mark,

The quickest way to duplicate a structure with no data is :

SELECT *
INTO new_table
FROM old_table
WHERE 1=2

The where clause will ensure that no data is populated, but you will end up with a mirror image table.

Tim