Re: How do I view the key contraints on Oracle7??

Dan Roberts (Roberts_Daniel_g.PRILVMS3_at_msmail.bms.com) wrote:

: --
: Netters...After I have created a table and created the primary and foreign
: key constriants..how do I view them to make sure I did it correctly??
 

: The describe table command jsut shows me attribute names and such
: and I just can't figure out how to view the key constraints.>thnaks for your
: hgelp.>>dan

Check out the user_ all_ dba_constraints views where table_name = etc...

--
Murray Kaiser                  | Usual gutless disclaimer.. 
Nova Scotia Power              | Opinions are mine and not necessarily
(Murray.Kaiser_at_NSPower.NS.CA)  | shared by my employer