Cascade delete

On Aug 2, 6:10 pm, Erland Sommarskog wrote:
> Mounilk ( ) writes:
> > I need to find out if the cascade delete option is set on any of the
> > tables in my database. Any help is greatly appreciated.
>
> Look up the catalog view sys.foreign_keys in Books Online.
>
> --
> Erland Sommarskog, SQL Server MVP, esq....RemoveThis@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Hi Erland,
Thank you very much for your reply.

I checked the sys.foreign_keys view and for all the FK's in the db,
the value for delete_referential_action_desc field is 'NO_ACTION'. But
somehow, if i delete a parent record, the child record is being
deleted too. Is there any other place I can look for this?

Cheers,
Mounilk
 >> Stay informed about: Cascade delete 

Probably you have a delete trigger on the table. Try running

Select name as triggername, OBJECT_NAME(parent_id) As tablename,* From
sys.triggers

to see if the table has triggers.

Tom

"Mounilk" wrote in message

On Aug 2, 6:10 pm, Erland Sommarskog wrote:
> Mounilk ( ) writes:
> > I need to find out if the cascade delete option is set on any of the
> > tables in my database. Any help is greatly appreciated.
>
> Look up the catalog view sys.foreign_keys in Books Online.
>
> --
> Erland Sommarskog, SQL Server MVP, esq... RemoveThis @sommarskog.se
>
> Books Online for SQL Server 2005
> athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000
> athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Hi Erland,
Thank you very much for your reply.

I checked the sys.foreign_keys view and for all the FK's in the db,
the value for delete_referential_action_desc field is 'NO_ACTION'. But
somehow, if i delete a parent record, the child record is being
deleted too. Is there any other place I can look for this?

Cheers,
Mounilk
 >> Stay informed about: Cascade delete