ALTER TABLE table_name RENAME TO new_table_name;
http://msdn.microsoft.com/en-us/library/ms188351%28v=sql.90%29.aspx