How to delete records from parent table which is referenced by multiple child tables?
<p>I have a table which is referenced by multiple tables (around 52) and further,few of the child tables have multiple foreign keys also that is referencing other tables too. </p>

<p>I want to delete a record from parent table, I am unable to do so, as I am getting error "The DELETE statement conflicted with the REFERENCE constraint "FK_xxx". The conflict occurred in database "MyDB", table "dbo.A", column 'x'."</p>

<p>I want a generalized T-SQL solution which is irrespective of tables and number of references. </p>