Subject | Help: Domain and referential integrity constraint |
---|---|
Author | Michael Fung <ibo@cmsweb.com> |
Post date | 2003-01-14T07:26Z |
Dear all,
The Data Def guide say:
"You cannot apply referential integrity constraints to a domain."
But I have the following worked okay:
ALTER TABLE SLAVE1 ADD CONSTRAINT FK_SLAVE1_MASTER1
FOREIGN KEY (MASTER_ID) REFERENCES MASTER1 (ID)
...
MASTER1.ID and SLAVE1.MASTER_ID are of a domain type.
I am using FB 1.0. Am I misunderstanding the guide?
Thanks,
Michael
The Data Def guide say:
"You cannot apply referential integrity constraints to a domain."
But I have the following worked okay:
ALTER TABLE SLAVE1 ADD CONSTRAINT FK_SLAVE1_MASTER1
FOREIGN KEY (MASTER_ID) REFERENCES MASTER1 (ID)
...
MASTER1.ID and SLAVE1.MASTER_ID are of a domain type.
I am using FB 1.0. Am I misunderstanding the guide?
Thanks,
Michael