What is the self-referencing constraint?
Answers were Sorted based on User's Feedback
Answer / s
Self-referencing constraint makes the table both the parent
and dependent table in the same referential constraint. The
foreign key to the table is defined after the table is
created.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mehdee
- To me it is when we create DB2 table and we use options
like, for example:
CONSTRAINT BONUS CHECK(BONUS <= SALARY)
OR
RESTRICT ON DROP
| Is This Answer Correct ? | 1 Yes | 0 No |
What does db2 blu stand for?
What is a bind in db2?
What is image copy in db2?
How to fetch the uncommited data from table ?
What is index cardinality?
pls explain the precompilation process of cobol-db2 pgm
What is query_cache_limit?
What does sqlcabc has?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What is the physical storage length of the data types date, time, and timestamp?
What is an instance database?
Which component is used to execute the sql statements?