Contents Index AUTO_REFETCH option [ISQL] BACKGROUND_PRIORITY option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

AUTOMATIC_TIMESTAMP option [compatibility]


Function 

Controls interpretation of new columns with the TIMESTAMP data type.

Allowed values 

ON, OFF

Default 

OFF

Description 

Controls whether any new columns with the TIMESTAMP data type that do not have an explicit default value defined are given a default value of the Transact-SQL timestamp value as a default. The AUTOMATIC_TIMESTAMP option is included for Transact-SQL compatibility. The default is OFF.

For more information, see Setting options for Transact-SQL compatibility.


Contents Index AUTO_REFETCH option [ISQL] BACKGROUND_PRIORITY option [database]