<div>
If you remove record from Child table effect also parent table. related parent table record also delete.
</div>


<div>
Please Ignore first post<br />
<br />
If you remove record from Parent table effect also Child table. related child table record also deleted.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
what are the negative effect of having on delete cascade set on foreign key of a child table?<br />
<br />
<br />
thanks 
</div>
</div>


Hi,

what are the negative effect of having on delete cascade set on foreign key of a child table?


thanks 

If you remove record from Child table effect also parent table. related parent table record also delete.

Please Ignore first post

If you remove record from Parent table effect also Child table. related child table record also deleted.

on delete cascade -sql 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.