Need alter constraint syntax for check constraint
Posted on 2001-07-27
I can't get this thing to work. I have added a new condition 'Billing Maintenance' and need to recompile the contraint. Do I have to drop it and add it? Do I need to drop the table and recreate it with the new value? It looks like all you can do with a alter constraint is turn it on and off. How do I do this.
ALTER TABLE ctms.requesttyperef MODIFY CONSTRAINT ck_requestflag
IN('Billing Maintenance','Deploy','Redeploy','Account Maintenance',
'Account Service','Supplies Maintenance', 'Third Party Equipment Billing'
,'Do Not Process','Customer Owned Services','Deploy Peripherals',
'Leasing Services','Convert','Internet Services','Salesperson Deploy'
,'Front End Conversion');