Re: Query to select "check" constraints?

From: Stan Brown <stanb_at_panix.com>
Date: 16 Aug 2001 18:55:50 -0400
Message-ID: <9lhj1m$de8$1@panix2.panix.com>

In <3B7C30FB.E650F70B_at_skynet.be> "Gerard H. Pille" <ghp_at_skynet.be> writes:

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

Thanks, I've been playing with that. but i can't seem to get the join of the 2 tables just right.

Sugestions? Received on Thu Aug 16 2001 - 17:55:50 CDT