SQL implementation How to modify the name of a table field _mssql

sp_rename N ' table name. Field name ', ' new field name ', ' column '
sp_rename
Changes the name of a user-created object (such as a table, column, or user-defined data type) in the current database.

Grammar
sp_rename [@objname =] ' object_name ',
[@newname =] ' New_name '
[, [@objtype =] ' object_type ']

parameters
[@objname =] ' object_name '

is the current name of a User object (table, view, column, stored procedure, trigger, default value, database, object, or rule) or data type. If the object you want to rename is a column in the table, then object_name must be a table.column form. If the index is to be renamed, then the object_name must be a table.index form. object_name is a nvarchar (776) type with no default value.

[@newname =] ' new_name '

is the new name of the specified object. New_name must be part of the name and follow the rules for identifiers. NewName is a sysname type with no default value.

[@objtype =] ' Object_type '

Is the type of object to rename. Object_type is a varchar (13) type with a default value of NULL and the following values are desirable.

Value Description
Column to rename.
Database user-defined databases. This option is required to rename the database.
Index user-defined indexes.
OBJECT is the type of item that is tracked in sysobjects. For example, object can be used to rename constraints (CHECK, FOREIGN key, Primary/unique key), user tables, views, stored procedures, triggers, and rules.
Userdatatype the user-defined data type that is added by executing the sp_addtype.

Return code value
0 (successful) or not 0 digits (failed)

notes
You can change only the object name or data type name in the current database. The names of most system data types and system objects cannot be changed.

When you rename a view, information about the view in the sysobjects table is updated. When you rename a stored procedure, information about the procedure in the sysobjects table is updated.

Whenever you rename a PRIMARY KEY or a UNIQUE constraint, sp_rename renames the associated index automatically. If the renamed index is associated with the PRIMARY key constraint, then sp_rename also automatically renames the primary key.

After important renaming stored procedures and views, clear the procedure cache to ensure that all related stored procedures and views are recompiled.

Renaming a stored procedure, view, or trigger does not change the name of the corresponding object in the syscomments table. Because the original name will be inserted into the CREATE statement from the syscomments table, this may cause problems when the script is generated for that object. For best results, do not rename these object types, and you should delete and re-create the objects with the new name.

Permissions
The sysadmin fixed server role members, db_owner, and db_ddladmin fixed database role members or object owners can perform sp_rename. Only the sysadmin and dbcreator fixed server role members can perform the sp_rename as a object_type.

sample
A. Renaming tables
The following example renames the table customers to custs.

EXEC sp_rename ' customers ', ' custs '

B. Renaming columns
The following example renames the column contact title in table customers to title.

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

Renaming columns: The following example renames the column contact title in table customers to title.

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