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';