Properties

Name: NOACTIONNOACTION 
Table schema: USER 
Table: USER.EMP_ACT 
Definer: USER 
Reference key: CC1151778928062 
Reference schema: USER 
Reference table: EMPLOYEE 
Delete rule: NO ACTION 
Update rule: NO ACTION 
Create time: 02.07.2006 
Foreign key colnames: EMPNO 
Primary key colnames: EMPNO 

SQL

ALTER TABLE "USER    "."EMP_ACT"
    ADD CONSTRAINT "NOACTIONNOACTION" FOREIGN KEY
        ("EMPNO")
    REFERENCES "USER    "."EMPLOYEE"
        ("EMPNO")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    ENFORCED
    ENABLE QUERY OPTIMIZATION;

See Also

List of foreign keys