Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.