Changing MS SQL Table Name with Query

To replace a table name with a query in MS SQL Server, the following procedure should be followed.

EXEC sp_rename {Old Table Name}, {New Table Name}

This is how it is used..

EXEC sp_rename 'OldTableName', 'NewTableName'

Note : When the relevant code runs, you will see that the table name has not changed in the left panel, Object Explorer. Therefore, the Tables folder in the database where the change is made should be Refresh.



You May Interest

What is the Maximum Number of Columns a Table in SQL Server ?

What are Replication and Database Mirroring in SQL Server ?

What are Table Valued Parameters ?

What are The Different Backup Options With SQL Server ?

General Information List of All Allowed Databases in MS SQL Serve ...