Categories
SQL SQL Server

sp_rename

Changes the name of a user-created object (i.e. table, column, or user-defined data type) in the current database.

Rename a table
This example renames the customers table to custs.

EXEC sp_rename 'customers', 'custs'

Rename a column
This example renames the contact title column in the customers table to title.

EXEC sp_rename 'customers.[contact title]', 'title', 'COLUMN'

Related posts:

  1. SQL Server Security: Database “db_datareader” Roles The db_datareader role The db_datareader role has the ability to...
  2. sp_change_users_login (Transact-SQL) Syntax sp_change_users_login [@Action =] 'action' [,[@UserNamePattern =] 'user'] [,[@LoginName =]...
  3. SQL 2005 Stored Procedures Last Modify Date USE Database --Change to the database you want to use...
  4. SQL Server Datatypes Data Types sql_variant: Stores values of various SQL Server-supported data...