Partilhar via


Interface IDatabaseOptions

Interface with properties that expose database options.

Essa API não é compatível com CLS. 

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
<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
'Uso
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

O tipo IDatabaseOptions expõe os membros a seguir.

Propriedades

  Nome Descrição
Propriedade pública AnsiNullDefault Gets or sets a Boolean property value that specifies whether the ANSI_NULL_DEFAULT database option is active.
Propriedade pública AnsiNullsEnabled Gets or sets a Boolean property value that specifies whether the ANSI_NULLS_ENABLED database option is active.
Propriedade pública AnsiPaddingEnabled Gets or sets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED database option is active.
Propriedade pública AnsiWarningsEnabled Gets or sets a Boolean property value that specifies whether the ANSI_WARNING_ENABLED database option is active.
Propriedade pública ArithmeticAbortEnabled Gets or sets a Boolean property value that specifies whether the ARITHMETICABORT database option is active.
Propriedade pública AutoClose Gets or sets a Boolean property value that specifies whether the AUTOCLOSE database option is active.
Propriedade pública AutoCreateStatisticsEnabled Gets or sets a Boolean property value that specifies whether the AUTOCREATESTATISTICS database option is active.
Propriedade pública AutoShrink Gets or sets a Boolean property value that specifies whether the AUTOSHRINK database option is active.
Propriedade pública AutoUpdateStatisticsAsync Gets or sets a Boolean property value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active.
Propriedade pública AutoUpdateStatisticsEnabled Specifies whether database statistics are automatically updated.
Propriedade pública BrokerEnabled Gets or sets a Boolean property value that specifies whether the Service Broker service is enabled.
Propriedade pública ChangeTrackingAutoCleanUp Gets or sets a Boolean property value that specifies whether the CHANGE_TRACKING_AUTO_CLEANUP OPTION is enabled.
Propriedade pública ChangeTrackingEnabled Gets or sets a value indicating whether change tracking is enabled.
Propriedade pública ChangeTrackingRetentionPeriod Gets or sets an interval that specifies how long change tracking information is retained.
Propriedade pública ChangeTrackingRetentionPeriodUnits Specifies the units for the change tracking retention period.
Propriedade pública CloseCursorsOnCommitEnabled Gets or sets a Boolean property value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.
Propriedade pública Collation Gets or sets the default collation used by the database.
Propriedade pública CompatibilityLevel Gets or sets the compatibility level for a database.
Propriedade pública ConcatenateNullYieldsNull Gets or sets a Boolean property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active.
Propriedade pública CreateDate Gets the date and time at which the database was created.
Propriedade pública DatabaseOwnershipChaining Indicates whether property ownership chaining is active.
Propriedade pública DatabaseSnapshotBaseName Gets the name of shapshot base for the database.
Propriedade pública DateCorrelationOptimization Gets or sets a Boolean property value that specifies whether the date correlation optimization is active.
Propriedade pública DefaultFileGroup Gets the default file group used by the database.
Propriedade pública DefaultFileStreamFileGroup Gets the default stream file group used by the database.
Propriedade pública EncryptionEnabled Gets or sets a value indicating whether encryption is enabled for the database.
Propriedade pública HonorBrokerPriority Gets or sets a value that indicates whether the priority specified by the broker is acknowledged.
Propriedade pública ID Gets the database ID value.
Propriedade pública IsParameterizationForced Gets or sets a Boolean property value that specifies whether parameterization is forced on the database.
Propriedade pública IsReadCommittedSnapshotOn Gets a value that specifies whether transactions with the read committed isolation level use row versioning.
Propriedade pública IsSystemObject Specifies whether the database is a system object or a user-defined database.
Propriedade pública IsUpdateable Indicates whether the database is updateable.
Propriedade pública LocalCursorsDefault Gets the Boolean value that specifies whether the local server cursors are used by default.
Propriedade pública 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.
Propriedade pública Name Gets the name of the database.
Propriedade pública NumericRoundAbortEnabled Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active.
Propriedade pública Owner Gets the the owner of the database.
Propriedade pública PageVerify Specifies the type of page integrity check that SQL Server performs when it reads database pages.
Propriedade pública PrimaryFilePath Gets the primary database file path.
Propriedade pública 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.
Propriedade pública ReadOnly Gets or sets the Boolean property value that specifies whether the database is read-only.
Propriedade pública RecoveryModel Gets or sets the recovery model for the database.
Propriedade pública RecursiveTriggersEnabled Gets or sets the Boolean value that specifies whether recursive triggers are enabled on the database.
Propriedade pública Trustworthy The TRUSTWORTHY database property is used to indicate whether the instance of SQL Server trusts the database and the contents within it.
Propriedade pública UserAccess Gets or sets the database user access.

Início

Consulte também

Referência