Re: oracle equivalent of sp_helpconstraint

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

<frank.van.bortel_at_gmail.com> wrote in message news:1171884545.989733.201060_at_t69g2000cwt.googlegroups.com...

> On 19 feb, 11:35, "Wilfrid" <grill..._at_yahoo.com> wrote:
>> Hello,
>>
>> I am looking for an oracle equivalent of sp_helpconstraint used SQL and Sybase.
>> So for i could find Describe tablename but it does not include the constraints (primary keys...) of the named table,
>> Is there a command in Oracle for that?
>>
>> thanks for you help
>
>
> It would probably help to describe what an sp_helpconstraint does.
> Would the comment command be of any help?
> comment on table <tab_name> is "your comment"; goes for columns as well
>
Received on Mon Feb 19 2007 - 05:54:04 CST