ISqlDatabaseOptions Interface

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 ISqlDatabaseOptions _
    Inherits ISqlExtendedPropertyHost, ISqlSecurable, ISqlModelElement, IScriptSourcedModelElement,  _
    IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

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

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

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

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

The ISqlDatabaseOptions type exposes the following members.

Properties

	Name	Description
	Collation	Gets or sets the database collation.
	CompatibilityMode	Gets or sets the compatibility mode of the database.
	DefaultFilegroup	Gets or sets the default filegroup.
	ElementClass	Gets the metadata class for an element. (Inherited from IModelElement.)
	ExtendedProperties	Gets the list of extended properties for this object. (Inherited from ISqlExtendedPropertyHost.)
	IsAnsiNullDefaultOn	Gets or sets a value that models the ANSI_NULLS_DEFAULT option.
	IsAnsiNullsOn	Gets or sets a value that models the ANSI_NULLS option.
	IsAnsiPaddingOn	Gets or sets a value that models the ANSI_PADDING option.
	IsAnsiWarningsOn	Gets or sets a value that models the ANSI_WARNINGS option.
	IsArithAbortOn	Gets or sets a value that models the ARITHABORT option.
	IsAutoCloseOn	Gets or sets a value that indicates whether AutoClose is enabled.
	IsAutoCreateStatisticsOn	Gets or sets a value that indicates whether AutoCreateStatistics is enabled.
	IsAutoShrinkOn	Gets or sets a value that indicates whether AutoShrink is enabled.
	IsAutoUpdateStatisticsOn	Gets or sets a value that indicates whether AutoUpdateStatistics is enabled.
	IsConcatNullYieldsNullOn	Gets or sets a value that models the CONCAT_NULL_YIELDS_NULL option.
	IsCursorCloseOnCommitOn	Gets or sets a value that models the CURSOR_CLOSE_ON_COMMIT option.
	IsCursorDefaultScopeGlobal	Gets or sets a value that indicates whether the default cursor scope is GLOBAL.
	IsDBChainingOn	Gets or sets a value that indicates whether database chaining is enabled.
	IsFullTextEnabled	True if full-text support is enabled.
	IsNumericRoundAbortOn	Gets or sets a value that models the NUMERIC_ROUND_ABORT option.
	IsOffline	Gets or sets a value that indicates whether the database state is set to OFFLINE.
	IsQuotedIdentifierOn	Gets or sets a value that models the QUOTED_IDENTIFIER option.
	IsReadOnly	Gets or sets a value that indicates whether the update state is READ_ONLY.
	IsRecursiveTriggersOn	Gets or sets a value that indicates whether recursive triggers are enabled.
	IsTornPageProtectionOn	Reverse compatibility only. Use the PageVerifyMode property instead.
	Model	Gets the model reference. (Inherited from IModelEntity.)
	Name	Gets or sets the name of the element. (Inherited from IModelElement.)
	Permissions	Gets the list of permissions that apply to this object. (Inherited from ISqlSecurable.)
	PrimarySource	Gets information about the primary source for the element. (Inherited from IScriptSourcedModelElement.)
	RecoveryMode	Gets or sets the database recovery mode.
	ResolutionStatus	Gets or sets the value of the model element resolution status. (Inherited from IModelElement.)
	SecondarySources	Gets a list of secondary sources for the element. (Inherited from IScriptSourcedModelElement.)
	SourceCodePositions	Gets the list of sources that define this element. (Inherited from IModelElement.)
	UserAccess	Gets or sets a value that models the user access options.
	ValidationStatus	Gets or sets the value of the model element validation status. (Inherited from IModelElement.)

Top

Methods

	Name	Description
	AddAnnotation	Adds the given annotation to this element. (Inherited from IModelAnnotationHolder.)
	Delete	Deletes this instance from the model. (Inherited from IModelElement.)
	GetAnnotations()	Returns a list of annotations attached to this element. (Inherited from IModelAnnotationHolder.)
	GetAnnotations(Type)	Returns a list of attached annotations of the given type. (Inherited from IModelAnnotationHolder.)
	GetAnnotations(ModelIdentifier)	Returns a list of attached annotations that have the given identifier. (Inherited from IModelAnnotationHolder.)
	GetAnnotations(ModelIdentifier, Type)	(Inherited from IModelAnnotationHolder.)
	GetAnnotations<TType>()	Returns all attached model annotations that implement the given annotation type and have the specified model identifier. (Inherited from IModelAnnotationHolder.)
	GetAnnotations<TType>(ModelIdentifier)	(Inherited from IModelAnnotationHolder.)
	GetComposingChildren	Returns a list of composing children for this element. (Inherited from IModelElement.)
	GetDefaultFilegroupRelationship	Returns an IModelSingleRelationship between this and the associated ISqlFilegroup.
	GetExtendedPropertiesRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISqlExtendedProperty. (Inherited from ISqlExtendedPropertyHost.)
	GetHierarchicalChildren	Returns a list of hierarchical children for this element. (Inherited from IModelElement.)
	GetOwnerInfo	Returns information about the element owner. (Inherited from IModelElement.)
	GetPermissionsRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISqlPermissionStatement. (Inherited from ISqlSecurable.)
	GetProperty<TProperty>	Gets the specified property. (Inherited from IModelPropertyContainer.)
	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.)
	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.)
	GetReferencedRelationshipEntries	Returns a list of the relationship entries, where this element is on the left side. (Inherited from IModelElement.)
	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.)
	GetReferencingRelationshipEntries	Returns a list of the relationship entries, where this element is on the right side. (Inherited from IModelElement.)
	GetRelationship(ModelRelationshipClass)	Returns the requested relationship by using the provided metadata. (Inherited from IModelElement.)
	GetRelationship<TFrom, TTo>(ModelRelationshipClass)	Returns a relationship where the two related elements are of the specified types. (Inherited from IModelElement.)
	GetRelationshipEntrySources	Returns a collection of source information about the given relationship. (Inherited from IScriptSourcedModelElement.)
	GetRelationships	Returns a list of the relationships in this element. (Inherited from IModelElement.)
	IsDeleted	Specifies whether the object is deleted. (Inherited from IModelElement.)
	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.)
	RemoveAnnotation	Removes the specified annotation from this model element. (Inherited from IModelAnnotationHolder.)
	SetProperty<TProperty>	Sets the specified property. (Inherited from IModelPropertyContainer.)

Top

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace