You didn't mention what database you are using. For SQL 2005 you can:

Select * into NewCategory from Category.

If you don't want to rename it you'll need to do something like:

Select * into #TempCategory
Drop table category
select * into Category from ##TempCategory

It would help to know what you are trying to achieve.