Re: How to get a list of constraints on a table?

In article <34982EA4.41C6_at_ribm00.rhic.bnl.gov>, gtsai_at_ribm00.rhic.bnl.gov says...
> One of my users asked me
>
> "What the sql is to get a list of all the constraints on a table
> i.e.(CONSTRAINT check_hum(humidity between 0 and 100)?"
>
> Any help would be greatly appreciated. Thanks in advance.

Have a look at the user_constraints view.

Hope this helps,
Haakon

--
Core Technology AS
www.core.no
hts_no_at_spam_core.no
(remove _no spam_ to reply)