共用方式為


IDatabaseOptions 介面

Interface with properties that expose database options.

此 API 不符合 CLS 標準。 

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<CLSCompliantAttribute(False)> _
<DisplayDescriptionKeyAttribute("IDatabaseOptions_Desc")> _
<StateChangeEventAttribute("CREATE_DATABASE", "DATABASE")> _
<StateChangeEventAttribute("ALTER_DATABASE", "DATABASE")> _
<StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "DATABASE")> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None Or AutomatedPolicyEvaluationMode.CheckOnChanges Or AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
<DisplayNameKeyAttribute("IDatabaseOptions_Name")> _
Public Interface IDatabaseOptions _
    Inherits IDmfFacet
'用途
Dim instance As IDatabaseOptions
[CLSCompliantAttribute(false)]
[DisplayDescriptionKeyAttribute("IDatabaseOptions_Desc")]
[StateChangeEventAttribute("CREATE_DATABASE", "DATABASE")]
[StateChangeEventAttribute("ALTER_DATABASE", "DATABASE")]
[StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "DATABASE")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayNameKeyAttribute("IDatabaseOptions_Name")]
public interface IDatabaseOptions : IDmfFacet
[CLSCompliantAttribute(false)]
[DisplayDescriptionKeyAttribute(L"IDatabaseOptions_Desc")]
[StateChangeEventAttribute(L"CREATE_DATABASE", L"DATABASE")]
[StateChangeEventAttribute(L"ALTER_DATABASE", L"DATABASE")]
[StateChangeEventAttribute(L"ALTER_AUTHORIZATION_DATABASE", L"DATABASE")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::None|AutomatedPolicyEvaluationMode::CheckOnChanges|AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute(L"Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayNameKeyAttribute(L"IDatabaseOptions_Name")]
public interface class IDatabaseOptions : IDmfFacet
[<CLSCompliantAttribute(false)>]
[<DisplayDescriptionKeyAttribute("IDatabaseOptions_Desc")>]
[<StateChangeEventAttribute("CREATE_DATABASE", "DATABASE")>]
[<StateChangeEventAttribute("ALTER_DATABASE", "DATABASE")>]
[<StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "DATABASE")>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")>]
[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
[<DisplayNameKeyAttribute("IDatabaseOptions_Name")>]
type IDatabaseOptions =  
    interface
        interface IDmfFacet
    end
public interface IDatabaseOptions extends IDmfFacet

IDatabaseOptions 型別公開下列成員。

屬性

  名稱 說明
公用屬性 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 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.
公用屬性 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.
公用屬性 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.

上層