Re: oracle equivalent of sp_helpconstraint

Thanks

I used this
select * from ALL_CONS_COLUMNS where owner = 'owner' and table_name = 'tablename' order by position

and worked fine

<frank.van.bortel_at_gmail.com> wrote in message news:1171891443.495843.182240_at_a75g2000cwd.googlegroups.com...
> 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 - 08:18:07 CST