Create table selecting from another

Hi!
I need to create a table and populate it with other table's contents. I know this can be done DTS, I wonder if there are means to make it throught a single TSQL command.
Thanks,
Fabio

Fabio

select * into new_table
from existing_table

Regards,
Lena


------------
Fabio Aneas at 3/5/01 11:49:04 AM

Hi!
I need to create a table and populate it with other table's contents. I know this can be done DTS, I wonder if there are means to make it throught a single TSQL command.
Thanks,
Fabio