Interested to Buy Any Domain ? << Click Here >> for more details...
What is the self-referencing constraint?
- 2 Answers
- 6307 Views
- I also Faced
- E-Mail Answers
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 schema the same as database?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
How to compare data between two tables in db2?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
What can the SET option of the Repair Utility accomplish?
What is usage pointer in cobol?
What Utility is used to migrate DB2 from one release to the next?
What is meant by index cardinality?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is lock escalation?
What are the three types of page locks that can be held?
COBOL 
