>Subject: check constraints
>From: adpctre_at_umassp.edu
>Date: 6/29/98 03:37 GMT
>Message-id: <6n8cbj$a7l$1_at_nnrp1.dejanews.com>
>
>I have a check (column) constraint. I need to either drop the constraint
>entirely or add some values to it. From the documentation, it looks like
>column constraints can't be modified and I can't figure out the syntax on how
>to drop or disable it.
>
>Can anyone tell me how to do this?
>
> Thanks.
>
Try
ALTER TABLE table_name DROP CONSTRAINT constraint_name;
HTH,
Rob
Received on Mon Jun 29 1998 - 13:24:50 CDT
