Sql

Question

How do u duplicate a table from one database into another database, using the “select *into”

Answer 1

Condition: Both tables contain the same data(columns + datatype) :
for my example i am using the 'dbo' schema.
Database to insert: DatabaseInsert
Database to copy: DatabaseCopy
Table in both databases: YourTableName

INSERT INTO DatabaseInsert.dbo.YourTableName
SELECT * FROM DatabaseCopy.dbo.YourTableName