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 |
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is syscat in db2?
What is PRIME TABLE and what are the uses of it
Describe what a storage group(STOGROUP) is?
What is db2 look?
what is the input to PLAN? what is the input to DBRM?
What is page size in db2?
wht steps we need will coding cobol and db2 pgm ?
What is db2 catalog database?
What is a clustering index ?
In terms of DB2 indexing, what is the root page?
What are bind parameters in db2?