Re: Some way to list all constraints?

"(Pete Cresswell)" wrote:
>
> Maybe this is another one of those "System Table" things...to which I have no
> access...
>
> I'm trying to clean out a DB so I can use it for testing a load routine but keep
> getting hit with "Unable to delete because of...(whatever constraint). In SQL
> Programmer I can view constraints on a table-by-table basis, but it seems like
> there should be some way for me to just list them all along with the table
> involved in each so I can just refer to the list instead of trying to guess the
> table.
>

You might want to look at the docco for DBA_CONSTRAINTS and DBA_CONS_COLUMNS. In case you weren't aware, the DBA_xxx views have ALL_xxx and USER_xxx counterparts - ALL_xxx showing those you can access, and USER_xxx showing those you own. There are somewhere around 100 of these 'triplets' of views, and they vary for each version (and frequently they vary subtly for each revision), so you might want to bookmark the docco for them.

HTH
/Hans Received on Mon Feb 16 2004 - 17:51:00 CST