AlterDatabaseOptionKind Enumeration
Enumeration specifies the kinds of options in ALTER DATABASE Transact-SQL statements.
Namespace: Microsoft.Data.Schema.ScriptDom.Sql
Assembly: Microsoft.Data.Schema.ScriptDom.Sql (in Microsoft.Data.Schema.ScriptDom.Sql.dll)
Syntax
'Declaration
Public Enumeration AlterDatabaseOptionKind
public enum AlterDatabaseOptionKind
public enum class AlterDatabaseOptionKind
type AlterDatabaseOptionKind
public enum AlterDatabaseOptionKind
Members
| Member name | Description | |
|---|---|---|
| Online | Value is 0 | |
| Offline | Value is 1 | |
| Emergency | Value is 2 | |
| SingleUser | Value is 3 | |
| RestrictedUser | Value is 4 | |
| MultiUser | Value is 5 | |
| ReadOnly | Value is 6 | |
| ReadWrite | Value is 7 | |
| EnableBroker | Value is 8 | |
| DisableBroker | Value is 9 | |
| NewBroker | Value is 10 | |
| ErrorBrokerConversations | Value is 11 | |
| DBChaining | Value is 12 | |
| Trustworthy | Value is 13 | |
| CursorCloseOnCommit | Value is 14 | |
| AutoClose | Value is 15 | |
| AutoCreateStatistics | Value is 16 | |
| AutoShrink | Value is 17 | |
| AutoUpdateStatistics | Value is 18 | |
| AutoUpdateStatisticsAsync | Value is 19 | |
| AnsiNullDefault | Value is 20 | |
| AnsiNulls | Value is 21 | |
| AnsiPadding | Value is 22 | |
| AnsiWarnings | Value is 23 | |
| ArithAbort | Value is 24 | |
| ConcatNullYieldsNull | Value is 25 | |
| NumericRoundAbort | Value is 26 | |
| QuotedIdentifier | Value is 27 | |
| RecursiveTriggers | Value is 28 | |
| TornPageDetection | Value is 29 | |
| DateCorrelationOptimization | Value is 30 | |
| AllowSnapshotIsolation | Value is 31 | |
| ReadCommittedSnapshot | Value is 32 | |
| Encryption | Value is 33 | |
| HonorBrokerPriority | Value is 34 | |
| VarDecimalStorageFormat | ||
| SupplementalLogging |
Remarks
Values of 0–11 are simple options. Values of 12–32 are on/off options. Values of 33–35 are on/off options that are specific to SQL Server 2008.