Named Constraints

Name all constraints (primary keys, foreign keys, defaults, and checks).

Named constraints should follow this pattern:

Primary key   <tableName>_PK
Foreign key, default, check <tableName>_<constraintIdentifier>_FK
Check <tableName>_<constraintIdentifier>_CK
Default <tableName>_<columnName>_DF

where constraintIdentifier is a unique string describing the constraint (e.g. CCPayment_UserID_FK).  Note that maximum constraint name length is 128 characters.