How to rename a table in SQL Server? To rename a table in SQL Server, use the sp_rename command: exec sp_rename 'schema.old_table_name', 'new_table_name'