Simple Constraint Question?

From: <liam_2e_at_my-deja.com>
Date: 2000/03/11
Message-ID: <8adolt$csd$1@nnrp1.deja.com>#1/1

Hello Everyone

I am currently working on a table, and I would like to drop a column from the table. This is what the table looks like. I would like to drop the region_no_foreign column except it has a child key. Here take a look. How to I find out what column in what table is refering to this column so I can remove the constraint??
Thanks for the help Liam

SQL> delete from state region_no_foreign; delete from state region_no_foreign

*
ERROR at line 1:
ORA-02292: integrity constraint (SYSTEM.SYS_C001880) violated - child record found

SQL> desc state

Name                                                  Null?    Type
----------------------------------------------------- -------- --------
STATE_CD                                              NOT NULL VARCHAR2


(2)

STATE_NM                                              NOT NULL VARCHAR2


(30)

REGION_NO                                                      NUMBER


(28)

REGION_NO_FOREIGN                                              NUMBER

(28)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Mar 11 2000 - 00:00:00 CST