How to check if a field is FK in another table?

Asked Oct 11 '15 at 08:41

Active Oct 11 '15 at 08:41

Viewed 66 times

I have the following table in Postgesql:

CREATE TABLE customers
(
  customerid integer NOT NULL,
  customerid2 text NOT NULL,
  ....
)

How can I check if customerid2 is used as FK in other tables? suppose I will drop this column, before it execute the actual drop - it checks who uses it. How do I perform that check manualy?

asked Oct 11 '15 at 08:41

SMW

1

http://stackoverflow.com/search?q=[postgresql]+find+foreign+keys – Oct 11 '15 at 09:24
Didn't find anything that works there. http://stackoverflow.com/questions/18383810/find-referenced-fields-of-foreign-key-constraint this was promiseing but it doesn't work. – SMW Oct 11 '15 at 11:49

How to check if a field is FK in another table?

0 Answers0