In both Oracle and MySQL, you can do:
create table T1 as select * from T1
This CREATE TABLE AS statement basically clones table T1 with its structure and data in T2. This can be pretty handy at times.
The equivalent of that in Sql Server is SELECT INTO. For example, you can do:
select * into T2 from T1
to achieve similar results.
2 thoughts on “CTAS and Select Into”