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

By | |
  • 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' , 'COLUMN'
Tagged . Bookmark the permalink.

Leave a Reply