Re: How to see Constraint name

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 18 Apr 2001 17:13:43 +0200
Message-ID: <9bkav8$ner$1_at_s1.read.news.oleane.net>


"Narayana" <tanarivs_at_hotmail.com> a écrit dans le message news: 3add9e5c_2_at_news01.one.net.au...
> I have a table with some unknown constraint.I would like to see the
> constraint Name.Could any one tell me waht is the command see the the
> Constraint Name of the Table.
>
> Thank you
>
>

select constraint_name from user_constraints where table_name='<Your table>';

--
Hope this helps
Michel
Received on Wed Apr 18 2001 - 17:13:43 CEST

Original text of this message