On 19 feb, 12:54, "Wilfrid" <grill..._at_yahoo.com> wrote:
> If i would execute
> sp_helpconstraint tablename
>
> would return:
>
> constraint_type constraint_name delete actions update actions status enabled status for replication constraint_keys
> PRIMARY KEY (clustered) PK_keyname (n/a) (n/a) (n/a) (n/a) id,name
>
> so i am looking for an oracle equivalent to display constraint information on a table.
>
> Thanks
>
Check the data dictionary: [dba|all]_constraints is the view you want.
All DD views : http://www.oracle.com/pls/db10g/db10g.catalog_views
Received on Mon Feb 19 2007 - 07:24:03 CST
