SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:33 PM
| ||||
| ||||
 Foreign Key On Delete Cascade Hello, If I have table the following table structure: Table Customer ( CustomerId Numeric(10,0) Not Null, ... ) Table CustomerOrders ( CustomerOrderId As Numeric(10,0) Not Null, CustomerId Numeric(10,0) Not Null, CustomerRefId Numeric (10,0) Not Null, ... ) Now if I try to apply the following Foreign Keys, listed below, the following error is displayed: "May cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints." ALTER TABLE CustomerOrders ADD CONSTRAINT FK_CustomerOrders_A FOREIGN KEY (CustomerId) REFERENCES Customer (CustomerId) ON DELETE CASCADE GO ALTER TABLE CustomerOrders ADD CONSTRAINT FK_CustomerOrders_B FOREIGN KEY (CustomerRefId ) REFERENCES CustomerRef (CustomerRefId ) ON DELETE CASCADE In ORACLE this works fine, I consider this to be a bug in MSS 2k. Does anybody know if microsoft is planning on changing this or if it works in "Yukon"? Thanks, Rob Panosh Advanced Software Designs      |
 |
« Total Replacing
|
Re: Getting the errrors Error: 5180,3624 and Could not open FCB for invalid file ID 17787 in database'te »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 03:27 PM.
