|
|||||||||||
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 |