SQL to Rename a Table of SQL Server

The builtin “sp_rename” procedure can be used to change or rename the name of an existing table. In this case, the existing name and new name must be provided to the sp_rename procedure.

SQL Syntax to Rename a Table:

EXEC sp_rename 'OldTableName', 'NewTableName'

For more detail on “sp_rename” CLICK HERE.

Posted in Database, SQL Server

Leave a Reply

Your email address will not be published. Required fields are marked *