New to SQL Server Copy Tables

[mts176]

How do you copy a table, as another name.

ex: tblpeople to tblpeopleX

I do not want to lose the original table

 

[Guest_imported]

You can execute following command.

select * into <new Table> from <old Table>

if you do not want to copy the data add any universal false condition.

Thanks.
Praveen

 

[Guest_imported]

Does the new table have to be already created? If so I don't want to have to do that. I want an exact duplicate of the original without having to create a table before hand

 

[dbmsguy]

Yes, that is exactly what it does.... you can even specify a subset of columns if you want

ie. select a, b, c, d into x from y Paul

http://www.dbmsguy.com