copy table 1

[ksbigfoot]

I am using SQL Server 2000.
I have 2 tables (Table1, Table2), that I want to copy and rename as (Table1Work, Table2Work).
Can someone point me in the right direction is how I should copy the tables with the same data.

Thanks

 

[manmaria]

select *
into Table1Work
from Table1;

Drop table Table1;

Similary for Table2.

HTH

 

[ksbigfoot]

Howdy manmaria,
Cool, star to you. It worked Perfectly.
ksbigfoot