* Yan Cheng CHEOK wrote:
I was wondering, is there any good way to drop a constraint? Currently, I am
making assumption on the check constraint name.
ALTER TABLE backup_table ADD CHECK (fk_lot_id = 99);
If I want to drop the above CHECK constraint, I will do
ALTER TABLE backup_table DROP C
Yes. You need to remove the row on pg_relcheck and then change the
value of relchecks for the row in pg_class for the relation the check
constraint is on.
On Wed, 7 Feb 2001, Tamsin wrote:
> Hello,
>
> Is it possible to drop a check constraint in any way without
> dropping/recreating the tabl