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

How to find primary key of a table in db2?

1062

What is nvl in db2?

1089

What is a storage group (stogroup)?

1241

How can we read records for specific member in CL? AND rpg?

696

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8280

Explain the function done by data manager?

1276

What is dbrm library?

1049

What is db2?

1178

How do I change the column size in db2?

1153

What is null indicator in cobol db2?

1063

List down the data types in the db2 database.

1117

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

1120

What is the result of open cursor statement?

1081

What are the 2 sqlcodes that are returned?

1187

What are the two types of logging in the db2 database? Explain them.

1071