You have data in your database that looks like Table 8-2. How can you prevent your users from entering invalid state abbreviations (like XZ) in the State field?

You have data in your database that looks like Table 8-2. How can you prevent your users from entering invalid state abbreviations (like XZ) in the State field?

You have data in your database that looks like Table 8-2. How can you prevent your users from entering invalid state abbreviations (like XZ) in the State field? 


Answer – Create a check constraint

(Check constraints restrict the data that is accepted in the field, even if the data are of the correct data type. So, you can use a check constraint to prevent users from entering invalid state abbreviations.)