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 |
Is ibm db2 free?
What are the bind parameters ibm db2?
What does DSNDB07 database do?
Can you search give an array in the WHERE clause of a db2 query?
What is performance tuning db2?
wt is view ? wht r the restrictions for view ?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is a db2 schema?
How would one remove old reorg information from the DB2 catalog?
What is null in db2?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is a root page?