SQL Select into a new table !

here is a pretty neat feature in SQL which I am just learning:

Tested on: SQL Server 2000

Select into a new table, which is created automatically for you.


select *
into myNewTable
from mySourceTable

I guess it might not be best for high-performance.
BUT it may come in handy.

After, you can drop the table:
drop table myNewTable