rename a table is MSSQL with the sp_rename sproc

EXEC sp_rename 'Foo', 'Bar';

... will rename the table named Foo to: "Bar"