What command do we use to rename a db, a table and a column?

To rename db

sp_renamedb ‘oldname’ , ‘newname’

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;

GO

EXEC sp_dboption AdventureWorks, ‘Single User’, True

GO

EXEC sp_renamedb ‘AdventureWorks’, ‘AdventureWorks_New’

GO

EXEC sp_dboption AdventureWorks, ‘Single User’, False

GO

To rename Table

We can change the table name using sp_rename as follows,

sp_rename ‘oldTableName’ ’newTableName’

E.g.

sp_RENAME ‘Table_First’, ‘Table_Last’
GO

To rename Column

The script for renaming any column :

sp_rename ‘TableName.[OldcolumnName]‘, ‘NewColumnName’, ‘Column’

E.g.sp_RENAME ‘Table_First.Name’, ‘NameChange’ , ‘COLUMN’
GO