Re: Drop constraint in PL@SQL

From the HTML docs at www.oracle.com

CASCADE CONSTRAINTS Specify CASCADE CONSTRAINTS to drop all referential integrity constraints that refer to primary and unique keys in the dropped table. If you omit this clause, and such referential integrity constraints exist, then Oracle returns an error and does not drop the table.

"MaisonBorniol" <maisonborniol_at_nomade.fr> wrote in message news:29f4fc84.0311052325.b62ccf4_at_posting.google.com...
> Thanks a lots,
>
>
> What I don't understand is wgy I have this error :
>
>
> ERREUR line 1 :
> ORA-02273: unique/primary key is refernced by foreign keys
> ORA-06512: line 16
>
> I'm doing this script in order to drop all my tables, but for that I
> have to drop all my constraint. And when I try to de that I have this
> error.
>
> How to drop all table (with foreign key references) for one user ?
>
> I don't want to drop the tables with a specific order....I would like
> to have a generic script.
>
> Thanks a lot for any help !
Received on Thu Nov 06 2003 - 08:53:01 CST