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>
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...Received on Tue Apr 10 2001 - 13:50:56 CEST
> 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
>
>