From: ivan marchesini <marchesini@unipg.it>
To: Postgres SQL language list <pgsql-sql@postgresql.org>
Subject: drop a check
Date: Mon, 13 Nov 2006 17:32:06 +0100
Message-ID: <1163435526.6395.27.camel@geoivan> (raw)
Dear all...
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?? :-)
many thanks...
Ivan
--
Ivan Marchesini
Department of Civil and Environmental Engineering
University of Perugia
Via G. Duranti 93/a
06125
Perugia (Italy)
e-mail: marchesini@unipg.it
ivan.marchesini@gmail.com
tel: +39(0)755853760
fax: +39(0)755853756
jabber: geoivan73@jabber.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: marchesini@unipg.it
Subject: Re: drop a check
In-Reply-To: <1163435526.6395.27.camel@geoivan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox