To find the constraints in a table
SELECT * FROM ALL_CONSTRAINTS
WHERE TABLE_NAME='TABLE_NAME'
AND OWNER = 'OWNER_NAME';
To find the constarints referring to a table
SELECT * FROM ALL_CONSTRAINTS
WHERE R_CONSTRAINT_NAME IN ( SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS WHERE TABLE_NAME='TABLE_NAME' )
AND OWNER = 'OWNER_NAME';
Use the share button below if you liked it.
It makes me smile, when I see it.