On Sat, 2003-11-22 at 16:53, Andreas Pflug wrote: > Stephan Szabo wrote: > > >You're going to potentially have the constraints scattered in any case due > >to circular dependency chains. I'd think that having all the constraints > >in one place would be easier than trying to go through the list of tables > >that might be in a circular chain in order to find the constraints. > > > > > I still disagree. cyclic dependencies should be avoided anyhow. You'll > get an awful lot of trouble loading data in such a case. Some database > systems refuse to create such stuff right away (mssql).
CREATE TABLE a (col integer primary key); CREATE TABLE b (col integer primary key); ALTER TABLE a ADD FOREIGN KEY (col) REFERENCES b INITIALLY DEFERRED; ALTER TABLE b ADD FOREIGN KEY (col) REFERENCES a; How does MSSQL deal with the above? ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
