Subject | Re: [ib-support] Implementing referential integrity |
---|---|
Author | Stevio |
Post date | 2002-06-26T16:16:27Z |
What is wrong with the following for adding a foreign key to a table?
ALTER TABLE BOOK ADD CODING_ID INTEGER;
ALTER TABLE BOOK ADD FOREIGN KEY (CODING_ID) REFERENCES CODING (CODING_ID);
Thanks,
Stephen
ALTER TABLE BOOK ADD CODING_ID INTEGER;
ALTER TABLE BOOK ADD FOREIGN KEY (CODING_ID) REFERENCES CODING (CODING_ID);
Thanks,
Stephen