Chapter 14: Defining Defaults and Rules for Data

A default is a value that Adaptive Server inserts into a column if a user does not explicitly enter one. In database management, a rule specifies what you are or are not allowed to enter in a particular column or in any column with a given user-defined datatype. You can use defaults and rules to help maintain the integrity of data across the database.