Re: Is Dropping a column "CHECK" constraint possible? - Mailing list pgsql-sql

> can anyone please help?
> i have a to drop a check contstraint from a column. eg
> 
> tradein_clients=# \d t_a
>            Table "t_a"
>    Column   |  Type   | Modifiers
> ------------+---------+-----------
>  company_id | integer |
>  exp        | text    |
>  imp        | text    |
> Check constraints: "$1" (length(imp) > 1)
>                    "aaaaaq" (length(imp) > 1)
> 
> Can i remove to contraints thru ALTER TABLE or similar commands.
> I have read the docs for ALTER TABLE but the command described is 
> not working for me.

This should work, so long as you're using postgres 7.2+

ALTER TABLE "t_a" DROP CONSTRAINT "aaaaaq" RESTRICT;

Chris