Home -> Usenet -> comp.databases.oracle -> Table/column constraints

Table/column constraints

From: Harold McCabe <mccabe_at_gdls.com>
Date: 1 Jul 1993 12:31:28 -0400
Message-ID: <20v3h0$4ah_at_gdls.gdls.com> 






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
Received on Thu Jul 01 1993 - 18:31:28 CEST












Original text of this message