Re: SQL for retrieving Constraints

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: 2000/05/13
Message-ID: <20000513.4370500@noname.nodomain.nowhere>#1/1

To get table descriptions from the SQL Plus prompt: DESC <table name>

To see constraints; just do a DESC on user constraints and then run a query against user constraints. If you are not logged on as the user DESC dba constraints and then run a query against dba constraints.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 5/12/00, 5:34:22 PM, code 1_at_my-deja.com wrote regarding SQL for retrieving Constraints:

> I am using Oracle for Windows 95 (Release 7.3.4),
> SQL Plus 3.3 and a test database. I would like to
> get table definitions and constraints using SQL.
> I tried the sp helpconstraint system stored
> procedure, but it doesn't work. It is not
> recognized as valid. I would like to get the data
> types, constraints, defaults, rules, and triggers
> of any table, using SQL.

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat May 13 2000 - 00:00:00 CDT