Check reference of Primary key

Question

is there any way to find out any reference of primary key value exist in Database.

 

Like 

Id	Country Name
1	India

 

Id	CountryId	State
1	1	Gujarat
2	1	Punjab

 

now, how can i find that india is in use in state table before delete.