Home -> Usenet -> comp.databases.oracle -> Determining column contraints for tables

Determining column contraints for tables

From: Brian Kildea <kildeab_at_bah.com>
Date: 24 Feb 1995 22:57:50 GMT
Message-ID: <3ilo9e$da4_at_booz.bah.com> 






I'm trying to understand the design of a rather large Oracle 7 
database with little to no documentation about it.



Specifically, I would like to know if there is any way to find out 
what columns are unique or primary keys.  I tried the 'describe'
command within SQL*Plus but it shows only column names and data
types.  I have not found anything in any books on Oracle.



Thanks in advance.  Please reply to my e-mail address:
kildeab_at_bah.com.
Received on Fri Feb 24 1995 - 23:57:50 CET












Original text of this message