Re: Viewing names of keys in sql plus?

From: InfoTech Consulting, Inc. <dmorse_at_iquest.net>
Date: 1998/09/14
Message-ID: <6tju9a$4n4$1@news.iquest.net>#1/1

I'm not positive on how to list p/f keys from sql*plus, but I can tell you that TOAD (from http://www.toadsoft.com) has an excellent, FREE tool that can tell you everything/anything you need to know!)

Paul Sian wrote in message ...
>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
Received on Mon Sep 14 1998 - 00:00:00 CDT