Re: Query to select "check" constraints?

From: Stan Brown <stanb_at_panix.com>
Date: 17 Aug 2001 19:42:37 -0400
Message-ID: <9lka5d$ckp$1@panix1.panix.com>

In <uitfm2j28.fsf_at_verizon.net> Galen Boyer <galenboyer_at_hotpop.com> writes:

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

Don't know, but since there are 543 different constraint names I would expect 543

>Also, you said 543 rows are returned.

>How many rows are in table BRKR?

< 50

???? Received on Fri Aug 17 2001 - 18:42:37 CDT