Hi All :

Thank you so much for the replies. I went with
---------------------------------------------------------------------------
select * into CopyOfEmployees from Employees where 1=0
---------------------------------------------------------------------------

as i need to archive the original tables data into a another table,
clear it out and be ready for new data that year.
So I have archive it and the new table name always had a year as a
prefix.

Thank you for all the help !!
-