RENAME COLUMN

Scope

SQL Syntax

  RENAME COLUMN [Owner.]TableName.ColumnName TO NewColumnName

Parameters

[Owner.]TableName.ColumnName

designates the table column to be renamed.

NewColumnName

is the new column name.

Description

• All indexes, columns, default columns, constraints, referential authorization, rules, and user authorities tables dependent on a renamed column will be renamed.

• All views dependent on a renamed column will be dropped.

• If a column has check constraints, then that column cannot be renamed.

Authorization

Example

   RENAME COLUMN Parts.PartNumber to NewPartNum;