sql servre 2000, ignorant's question: copy a table 1

[pssheba]

Hi !
a very basic question: I have a table in a database. I'd like to copy it to another database. how is it done ?

Thanks !

 

[bborissov]

It depends what you mean with COPY, do you want only data or you want the whole table with its indexes, triggers and all other constrains.

1. Copy only data:

SELECT * INTO NewDataBase.dbo.TableName FROM OldDataBase.dbo.TableName

2. Copy table with all other objects:
Run EM, right click on database name (in the Treeview on left). Choose All Task->Export data, then follow the wizard.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[pssheba]

Thanks a lot. I needed the 2 ways.