|
Home > Archive > MS SQL Server > March 2006 > Cycles or multiple cascade paths
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cycles or multiple cascade paths
|
|
|
| Hi,
How does Child table cause
cycles or multiple cascade paths? Why it cannot be handled by SQL Server?
USE TempDB
GO
CREATE TABLE Parent(
Col1 INT PRIMARY KEY
)
GO
CREATE TABLE Child(
Col1 INT REFERENCES Parent(Col1)
ON UPDATE CASCADE,
Col2 INT REFERENCES Parent(Col1)
ON UPDATE CASCADE
)
GO
Thanks in advance,
Leila
| |
| Evergray 2006-03-09, 3:23 am |
| Please, look at http://support.microsoft.com/kb/321843
--
WBR, Evergray
--
Words mean nothing...
"Leila" <Leilas@hotpop.com> wrote in message
news:OdAxv6uQGHA.5036@TK2MSFTNGP12.phx.gbl...
> Hi,
> How does Child table cause
> cycles or multiple cascade paths? Why it cannot be handled by SQL Server?
>
> USE TempDB
> GO
>
> CREATE TABLE Parent(
> Col1 INT PRIMARY KEY
> )
> GO
>
> CREATE TABLE Child(
> Col1 INT REFERENCES Parent(Col1)
> ON UPDATE CASCADE,
> Col2 INT REFERENCES Parent(Col1)
> ON UPDATE CASCADE
> )
> GO
>
>
> Thanks in advance,
> Leila
>
|
|
|
|
|