Re: Query to select "check" constraints?

"Stan Brown" <stanb_at_panix.com> wrote in message news:9lhbb8$64c$1_at_panix1.panix.com...
> 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).
>
>
>

select table_name, constraint_name, check_condition from user_constraints where constraint_type = ' C'

Hth,

Sybrand Bakker,
Senior Oracle DBA Received on Thu Aug 16 2001 - 17:36:33 CDT