쿼리] 컬럼별 제약조건 조회

SELECT b.table_name tb, a.column_name col, b.constraint_name const, b.search_condition condition
FROM user_cons_columns a JOIN user_constraints b
ON (a.constraint_name = b.constraint_name)

테이블명, 컬럼명, 제약조건명, 제약조건 상태