SQL Server – Create a Copy of a Table

SELECT * INTO dbo.NewTable FROM dbo.OldTable

Create only a subset of columns:

SELECT column5, column8, column11 INTO dbo.NewTable FROM dbo.OldTable