Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Viewing names of keys in sql plus?

Re: Viewing names of keys in sql plus?

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: 1998/09/17
Message-ID: <36015f13.0@news.cadvision.com>#1/1

Take a look in the all_constraints table. Column r_constraint_name will point to the parent table constraint (primary key).

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Nicola Taylor wrote in message <360121F2.ADE_at_gecm.com>...

>Paul Sian wrote:
>>
>> I am working on a database right now, basically just the framework.
>> Anyways there are some things I want to change. I need to drop a table
but
>> there is a key referenced in another table preventing me from doing that.
>> How do I show a list of the primary/foreign keys so I can know what key
to drop?
>> Thanks
>
>You could always try doing,
>
> DROP TABLE <table_name> CASCADE;
>
>This will drop the table and any foreign ket references to it all at the
>same time.
>
>Hope this helps!
Received on Thu Sep 17 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US