Pages

Sunday, December 4, 2011

Copy table from one database to another database

Example:

             SELECT * INTO db1.dbo.table1
             FROM db2.dbo.table2

Please mind that this query only copies table schema and data only.

All constraints, indexes, statatics, you need to use alternatives 

No comments:

Post a Comment