CREATE TABLE TB_MANAGER (EMPNO CHAR(6) PRIMARY KEY , 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 / sahil garg

3 Answers
6702 Views
I also Faced
E-Mail Answers

Answer Posted / sahil garg

CREATE TABLE TB_MANAGER
(EMPNO CHAR(6) PRIMARY KEY ,
MANAGER CHAR(6) );

ALTER TABLE TB_MANAGER
ADD CONSTRAINT TB_FK FOREIGN KEY (MANAGER) REFERENCES
TB_MANAGER(EMPNO);

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of db2 optimizer?

1042

Which are the db2 tools to protect integrity of the database?

1073

What is clone table?

998

What are the various isolation levels possible?

1050

What does db2 blu stand for?

1102

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

996

Which component is used to execute the sql statements?

1055

Mention the different locking levels that are available in db2.

1073

Differentiate between cs and rr isolation levels? Where do you specify them?

1025

What is db2? Explain.

989

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

993

Is the primary key a clustered index?

1080

what is a corelated subquerry?

1065

Which isolation level provides highest data integrity?

1043

What do you mean by storage group (stogroup)?

984