Use below query to get child key and foreign key status:

 

 

Enable constraints:

 

Find the parent table of child table: