How to check foreign key constraint failed for what reason.

See more:

SQL

MySQL

CodeIgniter

I have created a database in sqlserver with multiple tables and almost each tables are linked with foreign keys. Using PHP CodeIgniter as backend
Now as per general flow, when deleting/updating the record database verifys the foreign keys and if not matched it gives error.
here, what i want to do is to show the user proper message why the foreign key failed. That means, if i am trying to delete from parent table and it's referenced record exists in secondary table, instead of showing long un-understandable messge i want to show message like "You should delete the records from <secondary table="">" first.

My table structure is,
table1 :
<user_master< b="">

Id, name, email,password

Table 1: User_details
id,fk_user_master_id, address,phone



Also, if there are multiple foreign keys avaliable for the same table then i want to show the list of tables which will be conflicting the keys.

If exact records from reference tables which are preventing delete can also be retrieved then it will be great.

What I have tried:

I have successfully retrieved the foreignkeys assigned with the table using below query

SELECT 
   OBJECT_NAME(f.parent_object_id) TableName,
   COL_NAME(fc.parent_object_id,fc.parent_column_id) ColName
FROM 
   sys.foreign_keys AS f
INNER JOIN 
   sys.foreign_key_columns AS fc 
      ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN 
   sys.tables t 
      ON t.OBJECT_ID = fc.referenced_object_id
WHERE 
   OBJECT_NAME (f.referenced_object_id) = 'User_master'