List Oracle database contraints

Types of Contraints.
1. Primary Key
2. Foreign Key
3. Unique
4. Not Null
5. Check to enforce columns meet a specific condition

Query to list Oracle database contraints.

SELECT constraint_name, constraint_type, table_name, search_condition
FROM USER_CONSTRAINTS

About admin

Richard has worked in the Information Technology field for 25 years on a variety of platforms and lines of business.
This entry was posted in Oracle. Bookmark the permalink.