Implement Field-Level Rules
Before delving into how field-level validation is implemented, a study of the relevant field-level properties that support validation must be undertaken. In Chapter 2, “The Anatomy of a Real Database,” you were briefly introduced to these properties. In this chapter, you will be introduced to how these properties actually work to help enforce data integrity.
Field-Level Properties
Figure 6.1 illustrates the various properties of the ClientType field of the Client Table. Depending on how you want to configure your rules, you may use some or all the properties. Depending on the field data type, some properties may not apply. For example, the Allow Zero Length property would apply only to a text field and the Decimal ...
Get Absolute Beginner’s Guide to Databases now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
