Can we have Both Primary key and Foreign key on same column
user1849Dec 12 2002 — edited Dec 16 2002Hi all,
I have a question .Can we have both foriegn key and Primary on same column.
Please check the following script and please give me your feed back
Thanks for your help.
PROMPT Creating Primary Key on 'REGION'
ALTER TABLE REGION
ADD (CONSTRAINT REGION_PK PRIMARY KEY
(DEPT_CODE
,REGION_NUM))
PROMPT Creating Foreign Key on 'REGION'
ALTER TABLE REGION ADD (CONSTRAINT
REGION_FK FOREIGN KEY
(DEPT_CODE) REFERENCES DEPARTMENT
(DEPT_CODE))
/
PROMPT Creating Table 'REGION'
CREATE TABLE REGION
(DEPT_CODE VARCHAR2(2) NOT NULL
,REGION_NUM VARCHAR2(2) NOT NULL
,REGION_DEL_IND VARCHAR2(1) NOT NULL
,PAYR_AGCY_CODE VARCHAR2(5) NOT NULL
,ROWVERSION DATE NOT NULL
,CREATED_BY NUMBER(6) NOT NULL
,CREATED_DATE DATE NOT NULL
,UPDATED_BY NUMBER(6)
,UPDATED_DATE DATE
,CI_LESS_FCTR_PCT NUMBER
,CI_MORE_FCTR_PCT NUMBER
,CST_OVRUN_FCTR_PCT NUMBER
,REGION_DESC VARCHAR2(60)
,REGION_EXPIR_DATE DATE