Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle equivalent of sp_helpconstraint

Re: oracle equivalent of sp_helpconstraint

From: <frank.van.bortel_at_gmail.com>
Date: 19 Feb 2007 03:29:06 -0800
Message-ID: <1171884545.989733.201060@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:29:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US