Re: Query to select "check" constraints?

From: Stan Brown <stanb_at_panix.com>
Date: 16 Aug 2001 19:00:41 -0400
Message-ID: <9lhjap$e1e$1@panix2.panix.com>

In <998001398.13088.0.pluto.d4ee154e_at_news.demon.nl> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> writes:

>"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'

Thanks, I should have know that the oracle of Oracle would come thorugh! Received on Thu Aug 16 2001 - 18:00:41 CDT