Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
The DataServer Tutorial : Managing server attributes : Constraint definition names

Constraint definition names

Within Data Administration, constraint definitions are given default names as defined in the following table.
Table 55. Default constraint definition names
Constraint definition type
Default constraint definition name
Primary key
_PKC_ table-name-index-name- idx
Unique key
_UKC _table-name-index-name- idx
Foreign key
_FKC _parent-index-child index- idx
_CC _table-name-field-name- idx
_DC _table-name-field-name- idx
Clustered index
_CKC _table-name-index-name -idx