Category Archives: Oracle

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

Posted in Oracle | Comments Off on List Oracle database contraints