Change Name of any Table in SQL Server

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,

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

You can try below query :

Alter table MyName rename to MyName2