Above one is true but a small correction is needed as below: CREATE TAB

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.

Question Posted / shankar v

3 Answers
6970 Views
I also Faced
E-Mail Answers

Answer Posted / shankar v

Above one is true but a small correction is needed as below:

CREATE TABLE TB_MANAGER
(EMP-N0 CHAR(6) PRIMARY KEY NOT NULL,
MANAGER CHAR(6) NOT NULL)
IN TABLESPACE;

ALTER TABLE MANAGER
FOREIGN KEY (MANAGER) REFERENCES TB_MANAGER(EMP_NO)
ON DELETE CASCADE;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are types of indexes?

1187

What is null indicator in db2?

1162

What is explain in db2?

1078

What is a db2 table?

1064

Can we update view in db2?

1051

What is the difference between spufi and qmf?

1200

What is a trigger in the db2 database?

1140

How do I delete a column in db2?

1152

What is copy pending and check pending in db2?

1040

What is cobol db2?

1040

How to fetch the last row from the table in SQL (db2)?

1693

What is table space in db2?

1069

Can one database have multiple instances?

1095

What's The Percentage Free Space ?

1282

What is lock escalation in db2?

1078