How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign k

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

3 Answers
6697 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references ..

Answer / shankar v

Above one is true but a small correction is needed as below:

CREATE TABLE TB_MANAGER
(EMP-N0 CHAR(6) PRIMARY KEY NOT NULL,
MANAGER CHAR(6) NOT NULL)
IN TABLESPACE;

ALTER TABLE MANAGER
FOREIGN KEY (MANAGER) REFERENCES TB_MANAGER(EMP_NO)
ON DELETE CASCADE;

Is This Answer Correct ?

3 Yes

0 No

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references ..

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

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references ..

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