Creating a check constraint for multiple specific inputs

Question

I assumed it would be fine to execute SQL ommand something like this

Installation' OR 'Software Repair'

This didn't work so well so I tried

This didn't go so great either, I got a missing expression for Data Recovery

This gave me a cannot validate SYS.CH_SERVICETYPE -check constraint violated

Does this mean this constraint is already in place? If not

How can I enforce a Check Constraint for a table to require only specific values?

Thanks

Noel · Accepted Answer · 2013-05-13 03:41:51Z

3

Use the IN keyword.

ServiceType in ('Training', 'Data_Recovery', 'Consultation', 'Software  Installation', 'Software Repair')

answered May 13, 2013 at 3:41

Noel

10.6k30 gold badges53 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jim Over a year ago

Yeah I get cannot validate (SYS.CK_SERVICETYPE) - check constraint violated I guess this means that its already enforced ? Or there is like another constraint that is not allowing this to only = these values

Noel Over a year ago

That means, ServiceType column already has values other then what you have mentioned in the Constraint. Do a SELECT DISTINCT on ServiceType column to see what values it has.

Jim Over a year ago

Nah found it, had a _ in data type and a double space between Software and installation, it was case sensitive the current CK Thanks for the In statement, really helped out cheers!

Collectives™ on Stack Overflow

Creating a check constraint for multiple specific inputs

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related