|
|||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||||
A representation of the model object 'Foreign Key'.
Section 4.17
In the case that a table constraint is a referential constraint, the table is referred to as the referencing table. The referenced columns of a referential constraint shall be the unique columns of some unique constraint of the
referenced table.
Section 11.8
5) The referenced table shall be a base table.
Case:
a) If the referencing table is a persistent base table, then the referenced table shall be a persistent base table.
b) If the referencing table is a global temporary table, then the referenced table shall be a global temporary table.
c) If the referencing table is a created local temporary table, then the referenced table shall be either a global temporary table or a created local temporary table.
d) If the referencing table is a declared local temporary table, then the referenced table shall be either a global temporary table, a created local temporary table or a declared local temporary table.
6) If the referenced table is a temporary table with ON COMMIT DELETE ROWS specified, then the ref-erencing table shall specify ON COMMIT DELETE ROWS .
7) Each referencing column shall identify a column of the referencing table, and the same column shall not be identified more than once.
9) The
The following features are supported:
SQLConstraintsPackage.getForeignKey()| Method Summary | |
MatchType |
getMatch()
Returns the value of the 'Match' attribute. |
ReferentialActionType |
getOnDelete()
Returns the value of the 'On Delete' attribute. |
ReferentialActionType |
getOnUpdate()
Returns the value of the 'On Update' attribute. |
EList |
getReferencedMembers()
Returns the value of the 'Referenced Members' reference list. |
BaseTable |
getReferencedTable()
Returns the value of the 'Referenced Table' reference. |
UniqueConstraint |
getUniqueConstraint()
Returns the value of the 'Unique Constraint' reference. |
Index |
getUniqueIndex()
Returns the value of the 'Unique Index' reference. |
void |
setMatch(MatchType value)
Sets the value of the ' Match' attribute. |
void |
setOnDelete(ReferentialActionType value)
Sets the value of the ' On Delete' attribute. |
void |
setOnUpdate(ReferentialActionType value)
Sets the value of the ' On Update' attribute. |
void |
setReferencedTable(BaseTable value)
Sets the value of the ' Referenced Table' reference. |
void |
setUniqueConstraint(UniqueConstraint value)
Sets the value of the ' Unique Constraint' reference. |
void |
setUniqueIndex(Index value)
Sets the value of the ' Unique Index' reference. |
| Methods inherited from interface org.eclipse.datatools.modelbase.sql.constraints.ReferenceConstraint |
getMembers |
| Methods inherited from interface org.eclipse.datatools.modelbase.sql.constraints.TableConstraint |
getBaseTable, setBaseTable |
| Methods inherited from interface org.eclipse.datatools.modelbase.sql.constraints.Constraint |
isDeferrable, isEnforced, isInitiallyDeferred, setDeferrable, setEnforced, setInitiallyDeferred |
| Methods inherited from interface org.eclipse.datatools.modelbase.sql.schema.SQLObject |
addEAnnotation, addEAnnotationDetail, getDependencies, getDescription, getEAnnotation, getEAnnotationDetail, getLabel, removeEAnnotationDetail, setAnnotationDetail, setDescription, setLabel |
| Method Detail |
public MatchType getMatch()
"MATCH_SIMPLE".
The literals are from the enumeration MatchType.
If the meaning of the 'Match' attribute isn't clear, there really should be more of a description here...
MatchType,
setMatch(MatchType),
SQLConstraintsPackage.getForeignKey_Match()public void setMatch(MatchType value)
Match' attribute.
value - the new value of the 'Match' attribute.MatchType,
getMatch()public ReferentialActionType getOnUpdate()
"NO_ACTION".
The literals are from the enumeration ReferentialActionType.
If the meaning of the 'On Update' attribute isn't clear, there really should be more of a description here...
ReferentialActionType,
setOnUpdate(ReferentialActionType),
SQLConstraintsPackage.getForeignKey_OnUpdate()public void setOnUpdate(ReferentialActionType value)
On Update' attribute.
value - the new value of the 'On Update' attribute.ReferentialActionType,
getOnUpdate()public ReferentialActionType getOnDelete()
"NO_ACTION".
The literals are from the enumeration ReferentialActionType.
If the meaning of the 'On Delete' attribute isn't clear, there really should be more of a description here...
ReferentialActionType,
setOnDelete(ReferentialActionType),
SQLConstraintsPackage.getForeignKey_OnDelete()public void setOnDelete(ReferentialActionType value)
On Delete' attribute.
value - the new value of the 'On Delete' attribute.ReferentialActionType,
getOnDelete()public UniqueConstraint getUniqueConstraint()
Foreign Key'.
If the meaning of the 'Unique Constraint' reference isn't clear, there really should be more of a description here...
setUniqueConstraint(UniqueConstraint),
SQLConstraintsPackage.getForeignKey_UniqueConstraint(),
UniqueConstraint.getForeignKey()public void setUniqueConstraint(UniqueConstraint value)
Unique Constraint' reference.
value - the new value of the 'Unique Constraint' reference.getUniqueConstraint()public EList getReferencedMembers()
Column.
If the meaning of the 'Referenced Members' reference list isn't clear, there really should be more of a description here...
SQLConstraintsPackage.getForeignKey_ReferencedMembers()public Index getUniqueIndex()
Foreign Key'.
If the meaning of the 'Unique Index' reference isn't clear, there really should be more of a description here...
setUniqueIndex(Index),
SQLConstraintsPackage.getForeignKey_UniqueIndex(),
Index.getForeignKey()public void setUniqueIndex(Index value)
Unique Index' reference.
value - the new value of the 'Unique Index' reference.getUniqueIndex()public BaseTable getReferencedTable()
Referencing Foreign Keys'.
If the meaning of the 'Referenced Table' reference isn't clear, there really should be more of a description here...
setReferencedTable(BaseTable),
SQLConstraintsPackage.getForeignKey_ReferencedTable(),
BaseTable.getReferencingForeignKeys()public void setReferencedTable(BaseTable value)
Referenced Table' reference.
value - the new value of the 'Referenced Table' reference.getReferencedTable()
|
|||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||||