Re: Query to select "check" constraints?

From: Stan Brown <stanb_at_panix.com>
Date: 17 Aug 2001 09:52:20 -0400
Message-ID: <9lj7ik$6el$1@panix2.panix.com>

Hmm, this is closer:

select
C.table_name,
CC.COLUMN_NAME ,
SEARCH_CONDITION
from
USER_CONSTRAINTS C ,
USER_CONS_COLUMNS CC
where CONSTRAINT_TYPE = 'C'

AND CC.TABLE_NAME = 'BRKR'
AND CC.TABLE_NAME =  C.TABLE_NAME
AND CC.CONSTRAINT_NAME = C.CONSTRAINT_NAME

ORDER BY CC.TABLE_NAME But still returns 543 rows for this one table! And takes _a long_ time to run.

Can anyone show me the error of my ways? Received on Fri Aug 17 2001 - 08:52:20 CDT