Cascade Delete enumeration?

Hello,
Does anyone know a query I can run that will display all cascade actions (on
delete or otherwise) for all tables/relationships in a given database?
Thanks in advance
-Kerry-Something like:
select object_name(fkeyid) 'References',
object_name(rkeyid) 'Referenced',
case when ObjectProperty(r.constid, 'CnstIsDeleteCascade') = 1 then 'Yes'
else 'No' end 'DeleteCascade',
case when ObjectProperty(r.constid, 'CnstIsUpdateCascade') = 1 then 'Yes'
else 'No' end 'UpdateCascade'
from sysreferences r
where ObjectProperty(r.constid, 'CnstIsDeleteCascade') = 1
or ObjectProperty(r.constid, 'CnstIsUpdateCascade') = 1
Tom
"Kerry" <Kerry@.discussions.microsoft.com> wrote in message
news:9EFFA9D6-4C8E-400E-8A9E-BD08D9A0248F@.microsoft.com...
> Hello,
> Does anyone know a query I can run that will display all cascade actions
> (on
> delete or otherwise) for all tables/relationships in a given database?
> Thanks in advance
> -Kerry-|||Thank you Tom, I'll give it a try in the morning.
"Tom Cooper" wrote:

> Something like:
> select object_name(fkeyid) 'References',
> object_name(rkeyid) 'Referenced',
> case when ObjectProperty(r.constid, 'CnstIsDeleteCascade') = 1 then 'Yes'
> else 'No' end 'DeleteCascade',
> case when ObjectProperty(r.constid, 'CnstIsUpdateCascade') = 1 then 'Yes'
> else 'No' end 'UpdateCascade'
> from sysreferences r
> where ObjectProperty(r.constid, 'CnstIsDeleteCascade') = 1
> or ObjectProperty(r.constid, 'CnstIsUpdateCascade') = 1
> Tom
> "Kerry" <Kerry@.discussions.microsoft.com> wrote in message
> news:9EFFA9D6-4C8E-400E-8A9E-BD08D9A0248F@.microsoft.com...
>
>|||It worked, thanks Tom.
-Kerry-
"Tom Cooper" wrote:

> Something like:
> select object_name(fkeyid) 'References',
> object_name(rkeyid) 'Referenced',
> case when ObjectProperty(r.constid, 'CnstIsDeleteCascade') = 1 then 'Yes'
> else 'No' end 'DeleteCascade',
> case when ObjectProperty(r.constid, 'CnstIsUpdateCascade') = 1 then 'Yes'
> else 'No' end 'UpdateCascade'
> from sysreferences r
> where ObjectProperty(r.constid, 'CnstIsDeleteCascade') = 1
> or ObjectProperty(r.constid, 'CnstIsUpdateCascade') = 1
> Tom
> "Kerry" <Kerry@.discussions.microsoft.com> wrote in message
> news:9EFFA9D6-4C8E-400E-8A9E-BD08D9A0248F@.microsoft.com...
>
>