Re: Query to select "check" constraints?

Stan Brown wrote:
>
> How can I select the "check" constraints defined at table creation time
> with an SQL query, given the table name.
>
> I would like to know what collumn(s) have check constraints, and what those
> constraints are (as in what are legal values etc).

if you own the table, then you can query user_constraints and user_cons_columns,
user_constraints.constraint_type = 'C'

-- 

Gerard H. Pille