Antipattern: Specify Values in the Column Definition

Let's explore the insights we can derive from the antipattern 31 Flavors.

Many people choose to specify the valid data values when they define a column. The column definition is part of the metadata, which is the definition of the table structure itself.

For example, we could define a CHECK constraint on the column. This constraint disallows any insert or update that would make the constraint false.

Get hands-on with 1200+ tech skills courses.