Using the Database Diagram, you can create a Primary/Foreign Key relationship between two tables. But if the tables already have data, the relationship will fail to establish. If you are sure you won’t have orphaned data, the resolution is to set the ‘Check Existing Data On Creation Or Re-Enabling’ = “No” within the Foreign Key Relationships dialog box. The dialog box can be accessed when creating the relationship or by right clicking the table on the diagram and choosing ‘Relationships’.
SELECT * INTO dbo.NewTable FROM dbo.OldTable
Create only a subset of columns:
SELECT column5, column8, column11 INTO dbo.NewTable FROM dbo.OldTable