Re: Some way to list all constraints?

From: Vu Pham <vu_at_sivell.com>
Date: Tue, 17 Feb 2004 15:49:40 -0600
Message-ID: <c0u2b5$1catqm$1@ID-219297.news.uni-berlin.de>

"(Pete Cresswell)" <x_at_y.z> wrote in message news:vlj2309pgb6bnnme9g78dg34uqf3dhngpm_at_4ax.com...
> 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 can try this :

SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS; You can also replace USER_ by ALL_

Vu Received on Tue Feb 17 2004 - 15:49:40 CST