DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Copy Table From One Database To Another In MsSQL
This works in Microsoft SQL Server; don't know about other databases.
SELECT * INTO NewTable FROM existingdb.dbo.existingtable;