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