Posted onJanuary 10, 2011 by Josephine copy table from database to another SELECT * INTO AdventureWorks.dbo.CustomersTemp FROM Northwind.dbo.Customers Just remember that using this query will only transfer the schema and data. It does not transfer the indexes, foreign keys, statistics etc.