I am new to SQL. and this was in place when I started here.
I have a sql2000 database. It is opened with SQL Server manager 2005.
I have a table that needs to be archived every so often. The table is called TEST.
I need to copy the entire table ( data and columns) to a table called TEST01. Then need to erase all data in TEST so it is empty.
Should I rename TEST to TEST01 then copy the table structure to a new table call TEST?
How can I do this and what commands would it be.