MS SQL Server Rename Table
The RazorSQL alter table tool includes a Rename Table option for renaming an MS SQL Server database table. The rename table option allows the user to type in a new name for the table being renamed. The tool then generates and can execute the SQL to rename the MS SQL Server database table.
Listed below is an example of the SQL generated by the MS SQL Server Rename Table function:
exec sp_rename @objname = 'test.dbo.Employee',
@newname = 'Employee_new'
Below is a screen shot of the rename table function of the MS SQL Server alter table tool.
