Class ReferenceConstraint {Analysis} derived from: TableConstraint

Documentation
4.17.2 Table constraints

A table constraint is either a unique constraint, a referential constraint or a table check constraint. A table constraint is described by a table constraint descriptor which is either a unique constraint descriptor, a referential constraint descriptor or a table check constraint descriptor.

A referential constraint is described by a referential constraint descriptor. In addition to the components of every table constraint descriptor, a referential constraint descriptor includes:
- A list of the names of the referencing columns specified in the <referencing columns> .
- The referenced table specified in the <referenced table and columns> .
- A list of the names of the referenced columns specified in the <referenced table and columns> .
- The value of the <match type> , if specified, and the <referential triggered actions> , if specified.

NOTE 30: If MATCH FULL or MATCH PARTIAL is specified for a referential constraint and if the referencing table has only one column specified in <referential constraint definition> for that referential constraint, or if the referencing table has more than one specified column for that <referential constraint definition> , but none of those columns is nullable, then the effect is the same as if no <match type> were specified.

The ordering of the lists of referencing column names and referenced column names is implementation-defined, but shall be such that corresponding column names occupy corresponding positions in each list.


Parent PackageConstraintsAbstractYes
Export ControlPublicAccessLink Class forNone
Class KindNormalClassCardinalityn
Space ConcurrencySequential
PersistenceNo  


Attributes
NameClassTypeInitial Value
deferrableConstraintboolean 
initiallyDeferredConstraintbooleanfalse
nameSQLObjectString 
descriptionSQLObjectString 
labelSQLObjectString 


Associations
NameMy RoleMy ClassOther RoleOther Element
--Not Named----Not Named--ReferenceConstraintmembersColumn
table-constraintconstraintsTableConstraint--Not Named--BaseTable


Generalization Relationships
NameClassSupplier
--Not Named--ReferenceConstraintTableConstraint
--Not Named--TableConstraintConstraint
--Not Named--ConstraintSQLObject



Property Settings

Data Modeler
dmItemFalseDMName 
IsTableFalseIsViewFalse
IsDomainFalseIsSPPackageFalse
Synonymns TableSpaceID 
SourceId SourceType 
CorrelationName SelectClause 
IsUpdateableTrueCheckOptionNone
IsSnapShotFalseIsDistinctFalse
PersistToServer IsPackageFalse