Cloning tables in TSQL, as in Oracle CTAS

Explaining: the CREATE TABLE AS SELECT * FROM command, used to create a whole new table from an existing one (aka CTAS), and already importing its data, has a similar on Microsoft Transact-SQL:  SELECT * INTO NEW_TABLE FROM EXISTENT_TABLE .

It's quite simple like you were filling such a variable.