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?