Re: Viewing names of keys in sql plus?
From: Nicola Taylor <nicky.taylor_at_gecm.com>
Date: 1998/09/17
Message-ID: <360121F2.ADE_at_gecm.com>#1/1
Date: 1998/09/17
Message-ID: <360121F2.ADE_at_gecm.com>#1/1
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.
[Quoted]
> How do I show a list of the primary/foreign keys so I can know what key to drop?
> Thanks
[Quoted] 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 CEST