This section lists all database options.
OPTION
|
VALUES
|
DEFAULT
|
---|
AUDITING option [database]
|
ON, OFF
|
OFF
|
BACKGROUND_PRIORITY option [database]
|
ON, OFF
|
OFF
|
BLOCKING option [database]
|
ON, OFF
|
ON
|
BLOCKING_TIMEOUT option [database]
|
Integer
|
0
|
CHECKPOINT_TIME option [database]
|
Number of minutes
|
60
|
CIS_ROWSET_SIZE option [database]
|
Integer
|
50
|
COOPERATIVE_COMMIT_TIMEOUT option [database]
|
Integer
|
250
|
COOPERATIVE_COMMITS option [database]
|
ON, OFF
|
ON
|
DATE_FORMAT option [compatibility]
|
String
|
'YYYY-MM-DD'
|
DATE_ORDER option [compatibility]
|
'YMD', 'DMY', 'MDY'
|
'YMD'
|
DEFAULT_TIMESTAMP_INCREMENT option [database]
|
Integer
|
1
|
DELAYED_COMMIT_TIMEOUT option [database]
|
Integer
|
500
|
DELAYED_COMMITS option [database]
|
ON, OFF
|
OFF
|
EXTENDED_JOIN_SYNTAX option [database]
|
ON/OFF
|
ON
|
EXCLUDE_OPERATORS option [database]
|
reserved
|
reserved
|
FIRST_DAY_OF_WEEK option [database]
|
1, 2, 3, 4, 5, 6, 7
|
7
|
GLOBAL_DATABASE_ID option [database]
|
Integer
|
2147483647
|
ISOLATION_LEVEL option [compatibility]
|
0, 1, 2, 3
|
0
|
JAVA_HEAP_SIZE option [database]
|
Number of bytes
|
1 000 000
|
JAVA_NAMESPACE_SIZE option [database]
|
Number of bytes
|
4 000 000
|
LOGIN_MODE option [database]
|
STANDARD, MIXED, INTEGRATED
|
STANDARD
|
LOGIN_PROCEDURE option [database]
|
String
|
sp_login_environment
|
MAX_CURSOR_COUNT option [database]
|
Integer
|
50
|
MAX_HASH_SIZE option [database]
|
Integer
|
10
|
MAX_PLANS_CACHED option [database]
|
Integer
|
20
|
MAX_STATEMENT_COUNT option [database]
|
Integer >=0
|
50
|
MAX_WORK_TABLE_HASH_SIZE option [database]
|
Integer
|
20
|
MIN_PASSWORD_LENGTH option [database]
|
Integer
|
0
|
MIN_TABLE_SIZE_FOR_HISTOGRAM option [database]
|
Integer
|
1 000 rows
|
ON_CHARSET_CONVERSION_FAILURE option [database]
|
IGNORE, WARNING, ERROR
|
IGNORE
|
OPTIMISTIC_WAIT_FOR_COMMIT
|
ON, OFF
|
OFF
|
OPTIMIZATION_GOAL option [database]
|
First-row or all-rows
|
all-rows
|
PINNED_CURSOR_PERCENT_OF_CACHE option [database]
|
0-100
|
10
|
PRECISION option [database]
|
Number of digits
|
30
|
PREFETCH option [database]
|
ON, OFF
|
ON
|
PRESERVE_SOURCE_FORMAT option [database]
|
ON, OFF
|
ON
|
PREVENT_ARTICLE_PKEY_UPDATE option [database]
|
ON, OFF
|
ON
|
READ_PAST_DELETED option [database]
|
ON, OFF
|
ON
|
RECOVERY_TIME option [database]
|
Number of minutes
|
2
|
RETURN_DATE_TIME_AS_STRING option [database]
|
ON, OFF
|
OFF
|
RETURN_JAVA_AS_STRING option [database]
|
ON, OFF
|
OFF
|
ROW_COUNTS option [database]
|
ON, OFF
|
OFF
|
SCALE option [database]
|
Number of digits
|
6
|
SORT_COLLATION option [database]
|
any valid collation_name or collation_ID
|
Internal
|
SUBSUME_ROW_LOCKS option [database]
|
ON, OFF
|
ON
|
SUPPRESS_TDS_DEBUGGING option [database]
|
ON, OFF
|
OFF
|
TDS_EMPTY_STRING_IS_NULL option [database]
|
ON, OFF
|
OFF
|
TIME_FORMAT option [compatibility]
|
String
|
'HH:NN:SS.SSS'
|
TIME_ZONE_ADJUSTMENT option [database]
|
Integer, or Negative integer enclosed in quotation marks, or String representing time in hours and minutes, preceded by + or -
|
Set by either the client's or the server's time zone, depending on the client's connection type
|
TIMESTAMP_FORMAT option [compatibility]
|
String
|
'YYYY-MM-DD HH:NN:SS.SSS'
|
TRUNCATE_DATE_VALUES option [database]
|
ON, OFF
|
ON (post version 7 databases) OFF (pre version 7 databases)
|
TRUNCATE_TIMESTAMP_VALUES option [database]
|
ON, OFF
|
OFF
|
TRUNCATE_WITH_AUTO_COMMIT option [database]
|
ON, OFF
|
OFF
|
USER_ESTIMATES option [database]
|
ENABLED, OVERRIDE-MAGIC, DISABLED
|
OVERRIDE-MAGIC
|
UPDATE_STATISTICS option [database]
|
ON, OF
|
ON
|
WAIT_FOR_COMMIT option [database]
|
ON, OFF
|
OFF
|