restrict delete values from table.

Question

how to restrict delete values from table,

if the value refered in another table .

normally using add foreign key contsraint we can acheive this.

but this case i cannot set foreign key.

any way is there to restrict delete in sql?

Rajeev Punhani · Answer

Hi Durga Its better to use cascade delete using foreign key.But still if you want you can use Instead of delete trigger(In that trigger you can check for second table and if record is present then dont delete else remove record. Please check the below link for reference. http://www.aspsnippets.com/Articles/SQL-Server-Instead-Of-Delete-Trigger-Example.aspx If the above solution is helpful then accept the answer.