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
6802 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

Which component is responsible for processing sql statements and selecting access paths?

1113

what is diffrence b/w file-aid tool and file-aid utility???

4874

What is meant by union and union all?

986

What is meant by dclgen?

1093

What does db2 stand for?

995

Why do we bind in db2?

1195

What is iseries database?

1035

Mention the various locks that are available in db2.

1024

How and when does the db2 enforces the unique key?

1068

How is the value function used?

1135

What is check constraint. Explain with example.

1084

How do I import a csv file into db2?

966

What is schema in db2?

1006

How to find the number of rows in a db2 table?

1105

Is db2 a mainframe database?

975