Oracle7 Server Application Developer's Guide

CHAPTER 6. Maintaining Data Integrity

This chapter explains how to enforce the business rules associated with your database and prevent the entry of invalid information into tables by using integrity constraints. Topics include the following:

using integrity constraints

using referential integrity constraints

referential integrity in a distributed database

using CHECK integrity constraints

defining integrity constraints

enabling and disabling integrity constraints

altering and dropping integrity constraints

managing FOREIGN KEY constraints

listing constraint definitions

See the Trusted Oracle7 Server Administrator's Guide for additional information about defining, enabling, disabling, and dropping integrity constraints in Trusted Oracle.