To get all the constraints created in Oracle database, use below query.
SELECT * FROM USER_CONSTRAINTS;
If you want to get the constraints created for a particular user then use below SQL query.
SELECT * FROM USER_CONSTRAINTS where owner = 'userName';
If you want to get the more clear information like columns then use the below SQL query:
ReplyDeleteSELECT constraint_name, constraint_type, column_name from user_constraints natural join user_cons_columns where table_name = 'tableName';