Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Mandatory on one side of one to many?

Re: Mandatory on one side of one to many?

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: Sun, 5 Sep 2004 11:10:45 +0100
Message-ID: <EJ6dnXiHr_21e6fcRVn-vQ@giganews.com> 





Is this a SQL Server or Access or database theory question?



ANSI SQL92 allows DEFERRABLE constraints, which make it possible to 
implement these circular references. Unfortunately, SQL Server doesn't 
support this type of constraint. You could add an INSERT trigger to the 
Production table to insert an Event automatically. Or just insert to both 
tables in a transaction each time.



-- 



David Portas


SQL Server MVP


--

Received on Sun Sep 05 2004 - 05:10:45 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US