Re: Query to select "check" constraints?

On 17 Aug 2001, stanb_at_panix.com wrote:

> Thanks, I added that, but I'm still geting a lareg number of
> rows.

Do you get more than one row when you execute

select count(*)
from USER_CONSTRAINTS
where TABLE_NAME = 'BRKR'
and CONSTRAINT_TYPE = 'C'

Also, you said 543 rows are returned.

How many rows are in table BRKR?

-- 
Galen Boyer
It seems to me, I remember every single thing I know.