Rename Table MSSQL Database Server Tutorial

How To Rename Table In MSSQL Database Server Tutorial Example

Run microsoft sql server management studio query editor or any client tools you like then copy & paste the below code to rename a table usinq sql command or statement in MSSQL Database Server Tutorial Example

   exec sp_rename executives, executives_bk
 

   -- 'sp_rename' is a system stored procedure
   -- 'executives' old table name
   -- 'executives_bk' new table name

   -- is comment in MSSQL
   -- in fact it is comment in Oracle and MySQL as well

How To Rename Table In MSSQL Database Server Tutorial Example - Result in Microsoft Sql Server Management Studio Query Editor Client Tools