DB2® Version 8: The Official Guide

Using Informational Constraints

You can define informational constraints using the CREATE TABLE or ALTER TABLE statements. Within these statements, you add referential integrity or check constraints. You then associate constraint attributes to them, specifying whether you want the database manager to enforce the constraint or not and whether you want the constraint to be used for query optimization or not.

This section takes you through an example using informational constraints. Complete details on how to use them are available in the Information Center or the DB2 UDB SQL Reference manual.

Informational Constraints Example

To illustrate the use of informational constraints, first create a table called EMPLOYEEINFORMATION using the following ...