Re: Keys? Contraints?

From: Shawn Ellinger <sellinge_at_csac.com>
Date: Wed, 27 Sep 2000 21:53:45 GMT
Message-ID: <39D26B6A.D5BD07C1@csac.com>

look in sys.dba_contraints, sys.dba_cons_columns, sys.dba_indexs, sys.dba_ind_columns for the table and owner that you are looking for.

jscichocki_at_myezmail.com wrote:
>
> How do I find out what the keys and constraints of a table are. I did
> not create the table, but I am suppose to create a app that updates
> it. It is a general ledger table & I really don't need any mistakes to
> happen. I've tried the describe command, but that just gives me the
> basics. Can anyone help?
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 27 2000 - 16:53:45 CDT