You can list all constraints and tables to which they are linked via this SQL statement: SELECT constraint_name, Decode(constraint_type, ‘C’, ‘Check constraint on a table’, ‘P’, ‘Primary key’, ‘U’, ‘Unique key’, ‘R’, ‘Referential integrity’, ‘V’, ‘With check option, on a view’, ‘O’, ‘With read only, on a view’, ‘H’, ‘Hash expression’, ‘F’, ‘Constraint that involves […]