Icon DISABLE GENERATED

Disables the evaluation of generated column values for inserts and updates on a given table.

Syntax
DISABLE GENERATED ON <TableName>

Usage
Use this statement to disable the evaluation of generated column values on a table. By default, generated column values are enabled for all tables.

You can find out if generated column values are enabled or not by querying the Tables system information table.

Information Generated column values are enabled or disabled on a per-session basis, so this statement only affects the current session.

Examples
-- The following statement disables all generated column values on
-- the Customer table

DISABLE GENERATED ON "Customer"

Required Privileges
The current user must be granted the ALTER privilege on the specified table in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension.
Image