Oracle SQL Reference Manual says that table and column constraint
information ends up in CONSTRAINT_DEFS and CONSTRAINT_COLUMNS. This
seems to work OK for the one and only column constraint supported in
v 6: NOT NULL. But if I have something like:
create table test1 (value number(2) not null,
primary key (value))
create table test2 (value number(2) not null,
fk number(2), foreign key (fk) references
test1)
and I try to drop table test1 *BEFORE* I drop table test2 I see
ORA-02273: this unique/primary key is referenced by some foreign keys
Where is this information stored?? It does not show-up in CONSTRAINT_DEFS,
CONSTRAINT_COLUMNS, or CON$.
Harold McCabe
mccabe_at_gdls.com