What command do we use to rename a db, a table and a column?
To rename db sp_renamedb ‘old_database_name’ , ‘new_database_name’ If someone is using db it will not accept sp_renmaedb. In that case first bring db to single user using sp_dboptions. Use sp_renamedb to rename database. Use sp_dboptions to bring database to multi user mode. E.g. USE master; EXEC sp_dboption AdventureWorks, ‘Single User’, True EXEC sp_renamedb ‘AdventureWorks’, ‘AdventureWorks_New’ EXEC sp_dboption AdventureWorks, ‘Single User’, False To rename Table We can change the table name using sp_rename as follows, sp_rename ‘old_TableName’ ‘new_TableName’ E.g. sp_RENAME ‘Table_First’, ‘Table_Last’ To rename Column The script for renaming any column : sp_rename ‘TableName.[Old_columnName]‘, ‘New_ColumnName’, ‘Column’ E.g. sp_RENAME ‘Table_First.Name’, ‘NameChange’ , … Click here to continue reading.