CREATE TABLE QUALIFIER.TABLE (EMP-N0 CHAR(6) NOT NULL, MANAGER CHAR(6)

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 / s

3 Answers
6703 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

Please Help Members By Posting Answers For Below Questions

What is the difference between drop table and delete table?

1121

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1103

What is db2 and what is the use of db2 optimizer?

996

What is db2 look?

970

What is netezza database?

960

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1050

What is declare cursor?

1046

What is rebind in db2?

1001

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1182

What is the purpose of using commit?

1042

How do I create a view in db2?

976

What is runstats and reorg in db2?

1241

Give a brief description of db2 isolation levels?

1013

Is it possible using max on a char column?

1086

What is the role of union all and union

1070