0

I have a table called as customers and it has columns like id, name, address

Now I know for a fact that the id from customers is used as a Foreign key in a few tables but I dont know the whole list.

Is there a way I can find out all the tables that are dependent on records in customers table before I delete a particular record i.e. basically find out if my customers table or column from customers table has been used as a Foreign key in another table

john.p.doe
  • 411
  • 2
  • 10
  • 21
  • 2
    A quick google search has shown me this stack over flow question: http://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column -- perhaps it could help. – Lando Oct 15 '15 at 22:50
  • @Landen Thanks.. thats exactly what I was looking for. – john.p.doe Oct 15 '15 at 22:58

0 Answers0