Re: How to find constraints of a table using SQL

For constraints or anything else, take a look at Perl module DDL::Oracle, available from the CPAN, and from:

    http://sourceforge.net/projects/ddl-oracle/

Richard Sutherland

Zhou, Xiaodong <xdzhou_at_cs.ubc.ca> wrote in message news:977gjd$8a0$1_at_nntp.itservices.ubc.ca...
> Hi, there:
>
> I want to see the constraints(foreign key, primary key, etc.) of a table.
 I
> don't know how to do it in SQL. Will you please give me some advice?
> Thanks in advance!
>
> Yours xdzhou
>
>
Received on Sat Feb 24 2001 - 05:55:28 CST