How to split table into multiple tables using SQL

MS-SQL ,

  

1. Easiest way. Select... Into will create new tables:

SELECT 

    column1,

    column2

INTO NewTable

FROM OldTable

2. Drop the defunct columns from the original table:

ALTER TABLE OldTable DROP COLUMN column1

ALTER TABLE OldTable DROP COLUMN column2