Re: SQL for retrieving Constraints

I would really suggest you to start reading the Oracle reference documentation concerning the data dictionary field. These are very simple questions that a DBA can use SQL to query those data.

For table definition: do a desc on that table, or dba_constraints, dba_cons_columns, dba_tables, dba_tab_columns Triggers: dba_triggers

For more info, read the menu!

Winnie

code_1_at_my-deja.com wrote in message <8fi0td$6g$1_at_nnrp1.deja.com>...
>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