Change Name of any Table in SQL Server

Question

I want to know how to change name of any table in SQL server. Thank you.

Santhosh Kumar Jayaraman · Answer

--rename the new table with old table name tbl_test is my old table name tbl_Temp is new name Exec sp_rename 'tbl_Temp ' 'tbl_Test'

Jignesh Trivedi · Answer

hi Please refer... http://www.techonthenet.com/sql/tables/alter_table.php/ http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/ it is good article on same

Akkiraju Ivaturi · Answer

SP_Rename option is also available but you have to wisely use it Renaming a table USE AdventureWorks2012; GO EXEC sp_rename 'Sales.SalesTerritory' 'SalesTerr'; GO (Copied from MSDN) More can be had from the link http://msdn.microsoft.com/en-us/library/ms188351.aspx

Shen Hengbin · Answer

You can try below query : Alter table MyName rename to MyName2