ISql100DatabaseOptions Interface

  • Article

Models the settings on a database.

Namespace:  Microsoft.Data.Schema.Sql.SchemaModel
Assembly:  Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)

Syntax

'Declaration
Public Interface ISql100DatabaseOptions _
    Inherits ISql90DatabaseOptions, ISqlDatabaseOptions, ISqlExtendedPropertyHost, ISqlSecurable,  _
    ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity,  _
    IModelAnnotationHolder

public interface ISql100DatabaseOptions : ISql90DatabaseOptions, 
    ISqlDatabaseOptions, ISqlExtendedPropertyHost, ISqlSecurable, ISqlModelElement, IScriptSourcedModelElement, 
    IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

public interface class ISql100DatabaseOptions : ISql90DatabaseOptions, 
    ISqlDatabaseOptions, ISqlExtendedPropertyHost, ISqlSecurable, ISqlModelElement, IScriptSourcedModelElement, 
    IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

type ISql100DatabaseOptions =  
    interface
        interface ISql90DatabaseOptions
        interface ISqlDatabaseOptions
        interface ISqlExtendedPropertyHost
        interface ISqlSecurable
        interface ISqlModelElement
        interface IScriptSourcedModelElement
        interface IModelElement
        interface IModelPropertyContainer
        interface IModelEntity
        interface IModelAnnotationHolder
    end

public interface ISql100DatabaseOptions extends ISql90DatabaseOptions, ISqlDatabaseOptions, ISqlExtendedPropertyHost, ISqlSecurable, ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

The ISql100DatabaseOptions type exposes the following members.

Properties

  Name Description
Public property ChangeTrackingRetentionPeriod Gets or sets the retention period for change tracking.
Public property ChangeTrackingRetentionUnit Gets or sets the units for the change tracking retention period.
Public property Collation Gets or sets the database collation. (Inherited from ISqlDatabaseOptions.)
Public property CompatibilityMode Gets or sets the compatibility mode of the database. (Inherited from ISqlDatabaseOptions.)
Public property DefaultFilegroup Gets or sets the default filegroup. (Inherited from ISqlDatabaseOptions.)
Public property DefaultFileStreamFilegroup Gets or sets the default file stream file group.
Public property ElementClass Gets the metadata class for an element. (Inherited from IModelElement.)
Public property ExtendedProperties Gets the list of extended properties for this object. (Inherited from ISqlExtendedPropertyHost.)
Public property IsAllowSnapshotIsolation Gets or sets a value that models the ALLOW_SNAPSHOT_ISOLATION option. (Inherited from ISql90DatabaseOptions.)
Public property IsAnsiNullDefaultOn Gets or sets a value that models the ANSI_NULLS_DEFAULT option. (Inherited from ISqlDatabaseOptions.)
Public property IsAnsiNullsOn Gets or sets a value that models the ANSI_NULLS option. (Inherited from ISqlDatabaseOptions.)
Public property IsAnsiPaddingOn Gets or sets a value that models the ANSI_PADDING option. (Inherited from ISqlDatabaseOptions.)
Public property IsAnsiWarningsOn Gets or sets a value that models the ANSI_WARNINGS option. (Inherited from ISqlDatabaseOptions.)
Public property IsArithAbortOn Gets or sets a value that models the ARITHABORT option. (Inherited from ISqlDatabaseOptions.)
Public property IsAutoCloseOn Gets or sets a value that indicates whether AutoClose is enabled. (Inherited from ISqlDatabaseOptions.)
Public property IsAutoCreateStatisticsOn Gets or sets a value that indicates whether AutoCreateStatistics is enabled. (Inherited from ISqlDatabaseOptions.)
Public property IsAutoShrinkOn Gets or sets a value that indicates whether AutoShrink is enabled. (Inherited from ISqlDatabaseOptions.)
Public property IsAutoUpdateStatisticsAsyncOn Gets or sets a value that models the AUTO_UPDATE_STATISTICS_ASYNC flag. (Inherited from ISql90DatabaseOptions.)
Public property IsAutoUpdateStatisticsOn Gets or sets a value that indicates whether AutoUpdateStatistics is enabled. (Inherited from ISqlDatabaseOptions.)
Public property IsBrokerPriorityHonored Gets or sets a value that indicates whether broker priority is honored.
Public property IsChangeTrackingAutoCleanupOn Gets or sets a value that indicates whether auto cleanup is enabled for change tracking.
Public property IsChangeTrackingOn Gets or sets a value that indicates whether change tracking is enabled.
Public property IsConcatNullYieldsNullOn Gets or sets a value that models the CONCAT_NULL_YIELDS_NULL option. (Inherited from ISqlDatabaseOptions.)
Public property IsCursorCloseOnCommitOn Gets or sets a value that models the CURSOR_CLOSE_ON_COMMIT option. (Inherited from ISqlDatabaseOptions.)
Public property IsCursorDefaultScopeGlobal Gets or sets a value that indicates whether the default cursor scope is GLOBAL. (Inherited from ISqlDatabaseOptions.)
Public property IsDateCorrelationOptimizationOn Gets or sets a value that models the DATE_CORRELATION_OPTIMIZATION option. (Inherited from ISql90DatabaseOptions.)
Public property IsDBChainingOn Gets or sets a value that indicates whether database chaining is enabled. (Inherited from ISqlDatabaseOptions.)
Public property IsEncryptionOn Gets or sets a value that indicates whether encryption is enabled.
Public property IsFullTextEnabled True if full-text support is enabled. (Inherited from ISqlDatabaseOptions.)
Public property IsNumericRoundAbortOn Gets or sets a value that models the NUMERIC_ROUND_ABORT option. (Inherited from ISqlDatabaseOptions.)
Public property IsOffline Gets or sets a value that indicates whether the database state is set to OFFLINE. (Inherited from ISqlDatabaseOptions.)
Public property IsQuotedIdentifierOn Gets or sets a value that models the QUOTED_IDENTIFIER option. (Inherited from ISqlDatabaseOptions.)
Public property IsReadCommittedSnapshot Gets or sets a value that models the READ_COMMITTED_SNAPSHOT option. (Inherited from ISql90DatabaseOptions.)
Public property IsReadOnly Gets or sets a value that indicates whether the update state is READ_ONLY. (Inherited from ISqlDatabaseOptions.)
Public property IsRecursiveTriggersOn Gets or sets a value that indicates whether recursive triggers are enabled. (Inherited from ISqlDatabaseOptions.)
Public property IsSupplementalLoggingOn Gets or sets a value that indicates whether supplemental logging is enabled. (Inherited from ISql90DatabaseOptions.)
Public property IsTornPageProtectionOn Reverse compatibility only. Use the PageVerifyMode property instead. (Inherited from ISqlDatabaseOptions.)
Public property IsTrustworthyOn Gets or sets a value that indicates whether the TRUSTWORTHY setting is enabled. (Inherited from ISql90DatabaseOptions.)
Public property IsVardecimalStorageFormatOn Gets or sets a value that indicates whether the Vardecimal storage format support is enabled. (Inherited from ISql90DatabaseOptions.)
Public property Model Gets the model reference. (Inherited from IModelEntity.)
Public property Name Gets or sets the name of the element. (Inherited from IModelElement.)
Public property PageVerifyMode Gets or sets a value that models the PAGE_VERIFY option. (Inherited from ISql90DatabaseOptions.)
Public property ParameterizationOption Gets or sets a value that models the PARAMETERIZATION option. (Inherited from ISql90DatabaseOptions.)
Public property Permissions Gets the list of permissions that apply to this object. (Inherited from ISqlSecurable.)
Public property PrimarySource Gets information about the primary source for the element. (Inherited from IScriptSourcedModelElement.)
Public property RecoveryMode Gets or sets the database recovery mode. (Inherited from ISqlDatabaseOptions.)
Public property ResolutionStatus Gets or sets the value of the model element resolution status. (Inherited from IModelElement.)
Public property SecondarySources Gets a list of secondary sources for the element. (Inherited from IScriptSourcedModelElement.)
Public property ServiceBrokerOption Gets or sets a value that models the service broker options. (Inherited from ISql90DatabaseOptions.)
Public property SourceCodePositions Gets the list of sources that define this element. (Inherited from IModelElement.)
Public property UserAccess Gets or sets a value that models the user access options. (Inherited from ISqlDatabaseOptions.)
Public property ValidationStatus Gets or sets the value of the model element validation status. (Inherited from IModelElement.)
Public property VarDecimalStorageFormat Gets or sets a value that indicates whether vardecimal storage is enabled.

Top

Methods

  Name Description
Public method AddAnnotation Adds the given annotation to this element. (Inherited from IModelAnnotationHolder.)
Public method Delete Deletes this instance from the model. (Inherited from IModelElement.)
Public method GetAnnotations() Returns a list of annotations attached to this element. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(Type) Returns a list of attached annotations of the given type. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(ModelIdentifier) Returns a list of attached annotations that have the given identifier. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(ModelIdentifier, Type) (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations<TType>() Returns all attached model annotations that implement the given annotation type and have the specified model identifier. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations<TType>(ModelIdentifier) (Inherited from IModelAnnotationHolder.)
Public method GetComposingChildren Returns a list of composing children for this element. (Inherited from IModelElement.)
Public method GetDefaultFilegroupRelationship Returns an IModelSingleRelationship between this and the associated ISqlFilegroup. (Inherited from ISqlDatabaseOptions.)
Public method GetDefaultFileStreamFilegroupRelationship Returns an IModelSingleRelationship between this and the ISql100Filegroup.
Public method GetExtendedPropertiesRelationship Returns an IModelReverseMultiRelationship between this and the associated ISqlExtendedProperty. (Inherited from ISqlExtendedPropertyHost.)
Public method GetHierarchicalChildren Returns a list of hierarchical children for this element. (Inherited from IModelElement.)
Public method GetOwnerInfo Returns information about the element owner. (Inherited from IModelElement.)
Public method GetPermissionsRelationship Returns an IModelReverseMultiRelationship between this and the associated ISqlPermissionStatement. (Inherited from ISqlSecurable.)
Public method GetProperty<TProperty> Gets the specified property. (Inherited from IModelPropertyContainer.)
Public method GetReferencedDanglingRelationshipEntries Returns a list of the relationship entries, where this element is on the left side and there is either no element on the right side of the relationship, or the element on the right does not exist in the model. (Inherited from IModelElement.)
Public method GetReferencedElements Returns a list of the elements that are in a relationship with this element, where this element is on the left side of the relationship. (Inherited from IModelElement.)
Public method GetReferencedRelationshipEntries Returns a list of the relationship entries, where this element is on the left side. (Inherited from IModelElement.)
Public method GetReferencingElements Returns a list of the elements that are in a relationship with this element, where this element is on the right side. (Inherited from IModelElement.)
Public method GetReferencingRelationshipEntries Returns a list of the relationship entries, where this element is on the right side. (Inherited from IModelElement.)
Public method GetRelationship(ModelRelationshipClass) Returns the requested relationship by using the provided metadata. (Inherited from IModelElement.)
Public method GetRelationship<TFrom, TTo>(ModelRelationshipClass) Returns a relationship where the two related elements are of the specified types. (Inherited from IModelElement.)
Public method GetRelationshipEntrySources Returns a collection of source information about the given relationship. (Inherited from IScriptSourcedModelElement.)
Public method GetRelationships Returns a list of the relationships in this element. (Inherited from IModelElement.)
Public method IsDeleted Specifies whether the object is deleted. (Inherited from IModelElement.)
Public method IsExternal Returns a value that indicates whether the object was loaded from an external source and is not a part of the schema model. (Inherited from IModelElement.)
Public method RemoveAnnotation Removes the specified annotation from this model element. (Inherited from IModelAnnotationHolder.)
Public method SetProperty<TProperty> Sets the specified property. (Inherited from IModelPropertyContainer.)

Top

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace