For some of the tables I have foreign key triggers that apply to INSERT, UPDATE, and DELETE. When I create the table, do I explicitly name each one as an table constraint?
Example, I have three foreign key triggers, fki_comp_cat, fku_comp_cat, and fkd_comp_cat that ensure that records in the 'component' table match a record in the 'category' table, and that if an attempt is made to delete a category while there are component rows that reference it, the process aborts. So, do I write the ddl as: create table component(comp_id integer primary key, comp_cat text, comp_name text, CONSTRAINT fki_comp_cat, fku_comp_cat, fkd_comp_cat); I don't see this in Mike Owens' book. TIA, Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc.(TM) | Accelerator <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
