sp_rename
[@objname =] 'object_name',
[@newname =] 'new_name'
[, [@objtype =] 'object_type']
@objname | Original object name (in case of a column, the name of the column must be included). |
---|---|
@newname | New object name. |
@objtype | Type of the renamed object ('COLUMN', 'DATABASE', 'INDEX', 'OBJECT' or 'USERDATATYPE'). |
EXEC sp_rename 'data.time', 'when', 'COLUMN'