Tuesday, December 31, 2013

Rename SQL server DB - tables

Sol1 : just click on the table in Object explorer, hit F2 and rename it

Sol 2 :
EXECUTE sp_rename 'oldTableName' , 'newTableName'
EXECUTE sp_rename 'tb1' , 'tb2'
It really work try it.