Export (0) Print
Expand All

DatabaseOptionKind Enumeration

 

Applies To: SQL Server 2016 Preview

Specifies the kinds of database options.

Namespace:   Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

public enum DatabaseOptionKind

Member nameDescription
AllowSnapshotIsolation

The AllowSnapshotIsolation option.

AnsiNullDefault

The AnsiNullDefault option.

AnsiNulls

The AnsiNulls option.

AnsiPadding

The AnsiPadding option.

AnsiWarnings

The AnsiWarnings option.

ArithAbort

The ArithAbort option.

AutoClose

The AutoClose option.

AutoCreateStatistics

The AutoCreateStatistics option.

AutoShrink

The AutoShrink option.

AutoUpdateStatistics

The AutoUpdateStatistics option.

AutoUpdateStatisticsAsync

The AutoUpdateStatisticsAsync option.

ChangeTracking

The ChangeTracking option.

CompatibilityLevel

The CompatibilityLevel option.

ConcatNullYieldsNull

The ConcatNullYieldsNull option.

Containment

The Containment option.

CursorCloseOnCommit

The CursorCloseOnCommit option.

CursorDefault

The CursorDefault option.

DateCorrelationOptimization

The DateCorrelationOptimization option.

DBChaining

The DBChaining option.

DefaultFullTextLanguage

The DefaultFullTextLanguage option.

DefaultLanguage

The DefaultLanguage option.

DelayedDurability

The DelayedDurability option.

DisableBroker

The DisableBroker option.

Edition

The Edition option.

Emergency

The Emergency option.

EnableBroker

The EnableBroker option.

Encryption

The Encryption option.

ErrorBrokerConversations

The ErrorBrokerConversations option.

FileStream

The FileStream option.

Hadr

The Hadr option.

HonorBrokerPriority

The HonorBrokerPriority option.

MaxSize

The MaxSize option.

MemoryOptimizedData

The MemoryOptimizedData option.

MemoryOptimizedElevateToSnapshot

The MemoryOptimizedElevateToSnapshot option.

MultiUser

The MultiUser option.

NestedTriggers

The NestedTriggers option.

NewBroker

The NewBroker option.

NumericRoundAbort

The NumericRoundAbort option.

Offline

The Offline option.

Online

The Online option.

PageVerify

The PageVerify option.

Parameterization

The Parameterization option.

Partner

The Partner option.

QuotedIdentifier

The QuotedIdentifier option.

ReadCommittedSnapshot

The ReadCommittedSnapshot option.

ReadOnly

The ReadOnly option.

ReadWrite

The ReadWrite option.

Recovery

The Recovery option.

RecursiveTriggers

The RecursiveTriggers option.

RestrictedUser

The RestrictedUser option.

SingleUser

The SingleUser option.

SupplementalLogging

The SupplementalLogging option.

TargetRecoveryTime

The TargetRecoveryTime option.

TornPageDetection

The TornPageDetection option.

TransformNoiseWords

The TransformNoiseWords option.

Trustworthy

The Trustworthy option.

TwoDigitYearCutoff

The TwoDigitYearCutoff option.

VarDecimalStorageFormat

The VarDecimalStorageFormat option.

Witness

The Witness option.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft