Enforcing Data Integrity in the Eval Database

The Eval database uses constraints, triggers, and default values to maintain data integrity and to control values in tables. In some cases, you can use a constraint or a trigger, and the topics in the following list discuss why the Eval database designers chose to implement one over the other. SQL Server also offers Default, Rule, and UserDefinedDatatype objects to maintain data integrity; the following topics briefly describe these objects in the context of the Eval database.