IDatabaseOptions Interface
Represents an interface with properties that expose database options.
This API is not CLS-compliant.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "DATABASE")] [EvaluationModeAttribute(AutomatedPolicyEvaluationMode::None | AutomatedPolicyEvaluationMode::CheckOnChanges | AutomatedPolicyEvaluationMode::CheckOnSchedule)] [DisplayDescriptionKeyAttribute("IDatabaseOptions_Desc")] [StateChangeEventAttribute("CREATE_DATABASE", "DATABASE")] [StateChangeEventAttribute("ALTER_DATABASE", "DATABASE")] [CLSCompliantAttribute(false)] [LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")] [TypeConverterAttribute((LocalizableTypeConverter^::typeid))] [DisplayNameKeyAttribute("IDatabaseOptions_Name")] public interface class IDatabaseOptions : IDmfFacet
| Name | Description | |
|---|---|---|
![]() | 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. |
![]() | AutoCreateIncrementalStatisticsEnabled | Gets or sets a Boolean property value that specifies whether the AUTOCREATEINCREMENTALSTATICTICS database option is active. |
![]() | AutoCreateStatisticsEnabled | Gets or sets a Boolean property value that specifies whether the AUTOCREATESTATISTICS database option is active. |
![]() | 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 | Specifies whether database statistics are automatically updated. |
![]() | BrokerEnabled | Gets or sets a Boolean property value that specifies whether the Service Broker service is enabled. |
![]() | ChangeTrackingAutoCleanUp | Gets or sets a Boolean property value that specifies whether the CHANGE_TRACKING_AUTO_CLEANUP OPTION is enabled. |
![]() | ChangeTrackingEnabled | Gets or sets a value indicating whether change tracking is enabled. |
![]() | ChangeTrackingRetentionPeriod | Gets or sets an interval that specifies how long change tracking information is retained. |
![]() | ChangeTrackingRetentionPeriodUnits | Specifies the units for the change tracking retention period. |
![]() | CloseCursorsOnCommitEnabled | Gets or sets a Boolean property value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active. |
![]() | Collation | Gets or sets the default collation used by the database. |
![]() | CompatibilityLevel | Gets or sets the compatibility level for a database. |
![]() | ConcatenateNullYieldsNull | Gets or sets a Boolean property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active. |
![]() | CreateDate | Gets the date and time at which the database was created. |
![]() | DatabaseOwnershipChaining | Indicates whether property ownership chaining is active. |
![]() | DatabaseSnapshotBaseName | Gets the name of shapshot base for the database. |
![]() | DateCorrelationOptimization | Gets or sets a Boolean property value that specifies whether the date correlation optimization is active. |
![]() | DefaultFileGroup | Gets the default file group used by the database. |
![]() | DefaultFileStreamFileGroup | Gets the default stream file group used by the database. |
![]() | DelayedDurability | Gets or sets the delayed durability setting of a database. |
![]() | EncryptionEnabled | Gets or sets a value indicating whether encryption is enabled for the database. |
![]() | HonorBrokerPriority | Gets or sets a value that indicates whether the priority specified by the broker is acknowledged. |
![]() | ID | Gets the database ID value. |
![]() | IsParameterizationForced | Gets or sets a Boolean property value that specifies whether parameterization is forced on the database. |
![]() | IsReadCommittedSnapshotOn | Gets a value that specifies whether transactions with the read committed isolation level use row versioning. |
![]() | IsSystemObject | Specifies whether the database is a system object or a user-defined database. |
![]() | IsUpdateable | Indicates whether the database is updateable. |
![]() | 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 | Gets the name of the database. |
![]() | NumericRoundAbortEnabled | Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active. |
![]() | Owner | Gets the the owner of the database. |
![]() | PageVerify | Specifies the type of page integrity check that SQL Server performs when it reads database pages. |
![]() | PrimaryFilePath | Gets the primary database file path. |
![]() | 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. |
![]() | RemoteDataArchiveCredential | Gets the remote data archive credential. |
![]() | RemoteDataArchiveEnabled | Gets or sets a value that indicates whether remote data archive is enabled. |
![]() | RemoteDataArchiveEndpoint | Gets or sets the endpoint of the remote data. |
![]() | RemoteDataArchiveLinkedServer | Gets the linked server of remote data archive. |
![]() | RemoteDataArchiveUseFederatedServiceAccount | Gets a value indicating whether the remote data archive use federated service account. |
![]() | RemoteDatabaseName | Gets the name of the remote database. |
![]() | TargetRecoveryTime | Gets or sets the target recovery time. |
![]() | Trustworthy | The TRUSTWORTHY database property is used to indicate whether the instance of SQL Server trusts the database and the contents within it. |
![]() | UserAccess | Gets or sets the database user access. |
