<div>
Thanks that works. I also found the ObjectProperties function gives the result I want.<br />
<br />
select so.name, <br />
&nbsp; &nbsp; &nbsp; &nbsp;objectproperty(so.id, 'CnstIsDeleteCascade') AS DeleteCascade<br />
&nbsp; from sysforeignkeys fk<br />
&nbsp;inner join sysobjects so<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;on fk.constid = so.id<br />

</div>


Thanks that works. I also found the ObjectProperties function gives the result I want.

select so.name,
       objectproperty(so.id, 'CnstIsDeleteCascade') AS DeleteCascade
  from sysforeignkeys fk
 inner join sysobjects so
         on fk.constid = so.id


<div>
<div class="content wysiwyg-content">
I would like to identify whether a foreign key has the delete cascade option set by querying SQL Server system tables. <br />
I need a query which shows the FKs on a database and whenther the delete cascade option set.<br />
<br />

</div>
</div>


I would like to identify whether a foreign key has the delete cascade option set by querying SQL Server system tables. 
I need a query which shows the FKs on a database and whenther the delete cascade option set.



Identifying FKs with On Delete Cascade from a query.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.