Subject | Alter constraint |
---|---|
Author | helton |
Post date | 2002-11-21T15:53:42Z |
Hi all,
Given de table bellow, how can I alter the column constraint to another values after the table has been created ? Or I will have to drop the column and create it again ?
CREATE TABLE Test
(
FIELD1 CHAR NOT NULL CHECK (FIELD1 IN ('A','B'))
);
Thanks,
Helton
Given de table bellow, how can I alter the column constraint to another values after the table has been created ? Or I will have to drop the column and create it again ?
CREATE TABLE Test
(
FIELD1 CHAR NOT NULL CHECK (FIELD1 IN ('A','B'))
);
Thanks,
Helton