Display names of all constraints from Oracle database

Display names of all constraints from Oracle database

To display names of all constraints from Oracle database or from an specific table you can use: USER_CONSTRAINTS, ALL_CONSTRAINTS, DBA_CONSTRAINTS.

Examples

  
SELECT * FROM USER_CONSTRAINTS;

SELECT * FROM USER_CONSTRAINTS WHERE OWNER='SYSTEM';

SELECT * FROM USER_CONSTRAINTS 
WHERE OWNER='SYSTEM' AND TABLE_NAME='USERS';

SELECT * FROM ALL_CONSTRAINTS;

SELECT * FROM ALL_CONSTRAINTS WHERE OWNER='SYSTEM';

SELECT * FROM DBA_CONSTRAINTS;

SELECT * FROM DBA_CONSTRAINTS WHERE OWNER='SYSTEM';