• check constraints
•  

oracle

SELECT TABLE_NAME, CONSTRAINT_NAME, STATUS FROM USER_CONSTRAINTS

PostgreSQL

SELECT table_name, constraint_name FROM information_schema.table_constraints WHERE table_schema='public'