I have written the following constraint for a column I've called 'grade':
CONSTRAINT gradeRule CHECK grade IN (‘easy’, ‘moderate’, ‘difficult’),
Is it possible to later update the gradeRule
to have different values? For example, 'moderate' and 'difficult' could be changed to 'medium' and 'hard'.
Thanks