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
6734 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 do you simulate the explain of an embedded sql statement in spufi/qmf?

1051

What is database alias db2?

1081

What do you mean by storage group (stogroup)?

1000

Mention the location where the output received from explain statement is stored.

1084

Explain the contents that are a part of dclgen.

1048

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1069

What is the difference between oracle and db2?

1052

What is the difference between drop table and delete table?

1142

How many databases can be created inside an instance in db2 ?

994

What is db2 connect?

1022

Define data page.

1025

Which command is used to connect to a database in DB2 ? Give the Syntax.

1050

What is the cobol picture clause of the db2 data types date, time, timestamp?

1030

What is dbrm? When it will be created?

981

Explain about rct.

1038