How do I create a table MANAGER (EMP-NO, MANAGER) where
MANAGER is a foreign key which references to EMP-NO in the
same table? Give the exact DDL.
- 3 Answers
- 5627 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
CREATE TABLE QUALIFIER.TABLE
(EMP-N0 CHAR(6) NOT NULL,
MANAGER CHAR(6) NOT NULL)
IN TABLESPACE;
ALTER TABLE QUALIFIER.TABLE
FOREIGN KEY FKM (MANAGER) REFERENCES QUALIFIER.TABLE
ON DELETE CASCADE;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain the contention situations caused by locks?
How to retrieve rows from a db2 table in embedded sql?
Why do we bind in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is the difference between cursor stability and repeatable read isolation levels?
What is role in db2?
What is the information associated with sysibm.syslinks table?
Which command is used to remove all rows from a table?
What is node in db2?
What is the use of value function?
How do you eliminate duplicate values in db2?
What does db2 plan contain?
Explain the function of data manager.
What is the cobol picture clause of the db2 data types date, time, timestamp?
Define data page.
