Table Format

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

Table Format

Use the table format to change the mode of all database objects of a specified type that have been defined on the same table.

Table Format:
 
   .-,---------------.
   V                 |
|----+-CONSTRAINTS-+-+--FOR--table------------------------------>
     +-INDEXES-----+
     '-TRIGGERS----'
 
                                                  (1)
>--+-| Modes for Constraints and Unique Indexes |------+--------|
   |                                              (2)  |
   '-| Modes for Triggers and Duplicate Indexes |------'

Notes:

See page Modes for Constraints and Unique Indexes
See page Modes for Triggers and Duplicate Indexes

Element	Description	Restrictions	Syntax
table	Table on which objects are defined	Must be a local table. Objects defined on a temporary table cannot be set to disabled or filtering modes.	Database Object Name, p. Database Object Name

This example disables all constraints defined on the cust_subset table:

SET CONSTRAINTS FOR cust_subset DISABLED

In table format, you can change the modes of more than one database object type with a single statement. For example, this enables all constraints, indexes, and triggers that are defined on the cust_subset table:

SET CONSTRAINTS, INDEXES, TRIGGERS FOR cust_subset ENABLED