sp_rename TableNewName, ExistingTableName;

sp_renametable ExistingTableName, TableNewName;

sp_rename ExistingTableName, TableNewName;

sp_renametable TableNewName, ExistingTableName;