General information
Forum:
Microsoft SQL Server
Title:
Avoiding multiple cascade paths
Environment versions
SQL Server:
SQL Server 2005
Hi,
Given four tables:
Lists
Fields : ID
Columns
Fields : ID, ListId
Rows
Fields : ID, ListId
RowColumns
Fields: ID,RowId,ColumnId
If a row in the Lists table is deleted then I want to cascade the delete to both the Columns and Rows tables.
If a row in the Columns or Rows table is deleted then I want to cascade the delete to relevant rows in the RowColumns table.
If I try to set this up using relationships I can cascade the delete to RowColumns from either the Columns or the Rows table but not both - that causes a 'multiple cascade path error'. How can I achieve the desired behaviour ?
Regards,
Viv
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only