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
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