SQL

Copy table

SELECT * INTO [new-table-name] FROM [old-table-name]

Copy selected columns from table

SELECT [col1, col2, ...] INTO [new-table-name] FROM [old-table-name]