Synopsis: 31 Flavors
Let’s learn what happens if we restrict a column to use specific values.
We'll cover the following
In a personal contact information table, the salutation is a good example of a column with only a few values. Once we support Mr., Mrs., Ms., Dr., and Rev., we’ve accounted for virtually everyone. We could specify this list in the column definition, using a data type or a constraint, so that no one can accidentally enter an invalid string in the salutation column.
Get hands-on with 1200+ tech skills courses.