RENAME CONSTRAINT statement

Use the RENAME CONSTRAINT statement to rename the constraint. This statement is an extension to the ANSI/ISO standard for SQL.

Syntax

Read syntax diagramSkip visual syntax diagram RENAME CONSTRAINT owner. old_constraint TO new_constraint
Element Description Restrictions Syntax
new_constraint New name that you declare here for old_constraint Name must be unique to the database Identifier
old_constraint Constraint name that new_constraint replaces Must exist, but it cannot be a constraint on a system catalog table Identifier
owner Owner of old_constraint Must be the owner of old_constraint Owner name

Usage

You can rename a constraint if any of the following is true:
  • You are the owner of the constraint.
  • You have the DBA privilege on the database.

When you rename a constraint, the database server changes the constraint name in the sysconstraints and sysobjstate system catalog tables.