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 Package | Constraints | Abstract | Yes |
Export Control | PublicAccess | Link Class for | None |
Class Kind | NormalClass | Cardinality | n |
Space | | Concurrency | Sequential |
Persistence | No | | |
Attributes
Associations
Generalization Relationships
Property Settings
Data Modeler
dmItem | False | DMName | |
IsTable | False | IsView | False |
IsDomain | False | IsSPPackage | False |
Synonymns | | TableSpaceID | |
SourceId | | SourceType | |
CorrelationName | | SelectClause | |
IsUpdateable | True | CheckOption | None |
IsSnapShot | False | IsDistinct | False |
PersistToServer | | IsPackage | False |