Элементы IDatabaseOptions
Interface with properties that expose database options.
Тип IDatabaseOptions предоставляет доступ к следующим элементам.
Свойства
| Имя | Описание | |
|---|---|---|
.gif "Открытое свойство") |
AnsiNullDefault | Gets or sets a Boolean property value that specifies whether the ANSI_NULL_DEFAULT database option is active. |
|
AnsiNullsEnabled | Gets or sets a Boolean property value that specifies whether the ANSI_NULLS_ENABLED database option is active. |
|
AnsiPaddingEnabled | Gets or sets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED database option is active. |
|
AnsiWarningsEnabled | Gets or sets a Boolean property value that specifies whether the ANSI_WARNING_ENABLED database option is active. |
|
ArithmeticAbortEnabled | Gets or sets a Boolean property value that specifies whether the ARITHMETICABORT database option is active. |
|
AutoClose | Gets or sets a Boolean property value that specifies whether the AUTOCLOSE database option is active. |
|
AutoCreateStatisticsEnabled | |
|
AutoShrink | Gets or sets a Boolean property value that specifies whether the AUTOSHRINK database option is active. |
|
AutoUpdateStatisticsAsync | Gets or sets a Boolean property value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active. |
|
AutoUpdateStatisticsEnabled | |
|
BrokerEnabled | Gets or sets a Boolean property value that specifies whether the Service Broker service is enabled. |
|
ChangeTrackingAutoCleanUp | |
|
ChangeTrackingEnabled | |
|
ChangeTrackingRetentionPeriod | |
|
ChangeTrackingRetentionPeriodUnits | |
|
CloseCursorsOnCommitEnabled | Gets or sets a Boolean property value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active. |
|
Collation | |
|
CompatibilityLevel | |
|
ConcatenateNullYieldsNull | Gets or sets a Boolean property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active. |
|
CreateDate | |
|
DatabaseOwnershipChaining | |
|
DatabaseSnapshotBaseName | |
|
DateCorrelationOptimization | Gets or sets a Boolean property value that specifies whether the date correlation optimization is active. |
|
DefaultFileGroup | |
|
DefaultFileStreamFileGroup | |
|
EncryptionEnabled | |
|
HonorBrokerPriority | |
|
ID | |
|
IsParameterizationForced | Gets or sets a Boolean property value that specifies whether parameterization is forced on the database. |
|
IsReadCommittedSnapshotOn | |
|
IsSystemObject | |
|
IsUpdateable | |
|
LocalCursorsDefault | Gets the Boolean value that specifies whether the local server cursors are used by default. |
|
MirroringTimeout | Gets or sets the maximum time, in seconds, that the principal server instance waits for a PING message from another instance in the mirroring session before assuming the other instance is disconnected. |
|
Name | |
|
NumericRoundAbortEnabled | Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active. |
|
PageVerify | Specifies the type of page integrity check that SQL Server performs when it reads database pages. |
|
PrimaryFilePath | |
|
QuotedIdentifiersEnabled | Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks (" ") are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules. |
|
ReadOnly | Gets or sets the Boolean property value that specifies whether the database is read-only. |
|
RecoveryModel | Gets or sets the recovery model for the database. |
|
RecursiveTriggersEnabled | Gets or sets the Boolean value that specifies whether recursive triggers are enabled on the database. |
|
Trustworthy | |
|
UserAccess | Gets or sets the database user access. |
В начало
См. также