Re: check infomation of Primary key using SQL statement

From: Mark Malakanov <markmal_at_home.com>
Date: Tue, 10 Apr 2001 11:50:56 GMT
Message-ID: <AsCA6.72567$XV.18231618_at_news3.rdc1.on.home.com>


select from user_constraints, user_cons_columns

--
-----------------------------------------------------
Thanks,
Mark

"harvey" <harv_at_263.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:3ad2d38c$1_at_news.starhub.net.sg...

> Hi,
>
> Anyone know how to type SQL statement in SQLPLUS to
> get the name of the constraints defined on the table (Primary Key as well
as
> the Foreign key constraints)
> the names of the columns involved.
>
> Thanks a lot!
>
> harvey
> harv_at_263.net
>
>
Received on Tue Apr 10 2001 - 13:50:56 CEST

Original text of this message