Oracle

How to find Constraints on Oracle database

You need to find constraints of oracle database. Use below query for that.

SELECT *
FROM user_cons_columns
WHERE table_name = ”;

Further if you want to find more details on constraints then use below query.

(more…)

Advertisements