Over a million developers have joined DZone.

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;
Topics:

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}