Rename Table In SQL Server

How to Rename table In SQL Server 

 

       In SQL Server there no direct query to rename table. It can be possible using built in procedure in SQL server.

The following syntax help you to raname a table using procedure.

      EXEC sp_rename 'old_table_name', 'new_table_name' 


Rename table Using SSMS

     Another way to rename a table is Rght Click the table from  SQL Server Management Studio.