Re: drop a check

.....
or it depend on the fact I'm using postgres 7.4.13
many thanks...

Ivan

On lun, 2006-11-13 at 19:41 +0200, Volkan YAZICI wrote:
> On Nov 13 05:32, ivan marchesini wrote:
> > I have created a check constraint without giving it a name..
> > now I have a check named "$25" in my table that I need to drop or
> > modify!!!
> > How can I do???
> > with names is simple
> >
> > alter table tablename drop constraint constraintname;
> >
> > but without name?? :-)
>
> CREATE TABLE cons_test (
> u integer CHECK (u > 10)
> );
>
> SELECT constraint_name
> FROM information_schema.constraint_column_usage
> WHERE table_name = 'cons_test' AND
> column_name = 'u';
>
> See infoschema-constraint-column-usage.html in the manual for further
> assistance.
>
>
> Regards.
>
--
Ivan Marchesini
Department of Civil and Environmental Engineering
University of Perugia
Via G. Duranti 93/a
06125
Perugia (Italy)
e-mail: marchesini(at)unipg(dot)it
ivan(dot)marchesini(at)gmail(dot)com
tel: +39(0)755853760
fax: +39(0)755853756
jabber: geoivan73(at)jabber(dot)org