Rename DB, Table, Column,Stored Procedure,Index, View, Trigger
To rename database sp_renamedb 'Oldname', 'NewName' orsp_rename 'Oldname', 'NewName', 'DATABASE'; To rename Table column EXEC sp_ rename 'Table.Oldcolumn', 'Table.Newcolumn','COLUMN'; Example: rename object Test1 to Test2 . sp_rename 'dbo.Test1', 'Test2', 'OBJECT'; Example: rename an index from Test1 to IX_Test1 sp_rename 'dbo.Test.Test1', 'IX_test1', 'INDEX';