what is the Foreign key? explain?
- 2 Answers
- 6868 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gowrinag
FOREIGN KEY YFK (YNO) REFERENCES Y
ON DELETE CASCADE,
FOREIGN KEY ZFK (ZNO) REFERENCES Z
ON DELETE RESTRICT)
IN OZAGENDB.OZAGENTS;
ex:
CREATE TABLE YZ
(YNO CHAR(5) NOT NULL,
ZNO CHAR(5) NOT NULL,
QTYINTEGER,
PRIMARY KEY (YNO,ZNO),
FOREIGN KEY YFK (YNO) REFERENCES Y
ON DELETE CASCADE,
FOREIGN KEY ZFK (ZNO) REFERENCES Z
ON DELETE RESTRICT)
IN OZAGENDB.OZAGENTS;
---------+---------+---------+---------+---------
YNO ZNO QTY
---------+---------+---------+---------+--------
Y1 Z1 300
Y2 Z2 400
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / guest
A foreign key establishes the referential constraint
between a parent table and a dependent table
| Is This Answer Correct ? | 3 Yes | 3 No |
What does db2 blu stand for?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
Write a query to retrive partial string.
What is a LIKE table and how is it created?
What is the clustering index in the db2 database?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What are the uses of db2 optimizer?
pls explain the precompilation process of cobol-db2 pgm
What is db2 bind process?
What is null in db2?
How do I connect my db2 database to ibm?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
COBOL 
