Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 733
  • Last Modified:

Need alter constraint syntax for check constraint


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');
0
DonFreeman
Asked:
DonFreeman
1 Solution
 
leolkkCommented:
If there are NEW values,
1) i am used to drop the "CONSTRAINT" first.
2) after updating corresponding data. I will then add a new constraint.

If there is NO new values,
1) I turn it off
2) update data
3) turn it on again
0
 
ser6398Commented:
Try the following:

ALTER TABLE ctms.requesttyperef MODIFY CONSTRAINT ck_requestflag CHECK (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'));
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now