Default Values in Eval Table Columns

The Eval database assigns default values to a number of columns by defining a default value in the Default Value column attribute; for example, the Group table has the default value of 0 in the Size column. When a new group record is added to the table and does not have any members, SQL Server enters a 0 in the Size column. The following tables use default values:

An alternative to entering default values for each column is to use the Default object. This works well when you are using the same default value in more than one column; the Default object ensures that default values are consistent, and when a default value changes, you need only change the value in one place. You can also bind the Default object to a user-defined data type to automatically assign a default value whenever you use the user-defined data type.

The Eval database has no Default objects, but if the database designers knew that the PT application would be used only within a known locale, they could create Default objects for some of the address columns, such as the City, Region, PostalCode, and Country columns in the Location and Person tables.