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

I have the following table:

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?


Source: sql

Leave a Reply