Modes for Constraints and Unique Indexes

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements > SET Database Object Mode >

Modes for Constraints and Unique Indexes

You can specify enabled or disabled mode for a constraint or a unique index.

Modes for Constraints and Unique Indexes:
 
   .-ENABLED----------------------.
|--+-DISABLED---------------------+-----------------------------|
   |            .-WITHOUT ERROR-. |
   '-FILTERING--+-WITH ERROR----+-'

If you specify no mode for a constraint in a CREATE TABLE, ALTER TABLE, or SET Database Object Mode statement, the constraint is enabled by default. If you do not specify the mode for an index in the CREATE INDEX or SET Database Object Mode statement, the index is enabled by default.

Definitions of Database Object Modes

You can use database object modes to control the effects of INSERT, DELETE, and UPDATE statements. Your choice of mode affects the tables whose data you are manipulating, the behavior of the database objects defined on those tables, and the behavior of the data manipulation statements themselves.