ISql100DatabaseOptions 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 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 | |
|---|---|---|
.gif "Public property") |
ChangeTrackingRetentionPeriod | Gets or sets the retention period for change tracking. |
|
ChangeTrackingRetentionUnit | Gets or sets the units for the change tracking retention period. |
|
Collation | Gets or sets the database collation. (Inherited from ISqlDatabaseOptions.) |
|
CompatibilityMode | Gets or sets the compatibility mode of the database. (Inherited from ISqlDatabaseOptions.) |
|
DefaultFilegroup | Gets or sets the default filegroup. (Inherited from ISqlDatabaseOptions.) |
|
DefaultFileStreamFilegroup | Gets or sets the default file stream file group. |
|
ElementClass | Gets the metadata class for an element. (Inherited from IModelElement.) |
|
ExtendedProperties | Gets the list of extended properties for this object. (Inherited from ISqlExtendedPropertyHost.) |
|
IsAllowSnapshotIsolation | Gets or sets a value that models the ALLOW_SNAPSHOT_ISOLATION option. (Inherited from ISql90DatabaseOptions.) |
|
IsAnsiNullDefaultOn | Gets or sets a value that models the ANSI_NULLS_DEFAULT option. (Inherited from ISqlDatabaseOptions.) |
|
IsAnsiNullsOn | Gets or sets a value that models the ANSI_NULLS option. (Inherited from ISqlDatabaseOptions.) |
|
IsAnsiPaddingOn | Gets or sets a value that models the ANSI_PADDING option. (Inherited from ISqlDatabaseOptions.) |
|
IsAnsiWarningsOn | Gets or sets a value that models the ANSI_WARNINGS option. (Inherited from ISqlDatabaseOptions.) |
|
IsArithAbortOn | Gets or sets a value that models the ARITHABORT option. (Inherited from ISqlDatabaseOptions.) |
|
IsAutoCloseOn | Gets or sets a value that indicates whether AutoClose is enabled. (Inherited from ISqlDatabaseOptions.) |
|
IsAutoCreateStatisticsOn | Gets or sets a value that indicates whether AutoCreateStatistics is enabled. (Inherited from ISqlDatabaseOptions.) |
|
IsAutoShrinkOn | Gets or sets a value that indicates whether AutoShrink is enabled. (Inherited from ISqlDatabaseOptions.) |
|
IsAutoUpdateStatisticsAsyncOn | Gets or sets a value that models the AUTO_UPDATE_STATISTICS_ASYNC flag. (Inherited from ISql90DatabaseOptions.) |
|
IsAutoUpdateStatisticsOn | Gets or sets a value that indicates whether AutoUpdateStatistics is enabled. (Inherited from ISqlDatabaseOptions.) |
|
IsBrokerPriorityHonored | Gets or sets a value that indicates whether broker priority is honored. |
|
IsChangeTrackingAutoCleanupOn | Gets or sets a value that indicates whether auto cleanup is enabled for change tracking. |
|
IsChangeTrackingOn | Gets or sets a value that indicates whether change tracking is enabled. |
|
IsConcatNullYieldsNullOn | Gets or sets a value that models the CONCAT_NULL_YIELDS_NULL option. (Inherited from ISqlDatabaseOptions.) |
|
IsCursorCloseOnCommitOn | Gets or sets a value that models the CURSOR_CLOSE_ON_COMMIT option. (Inherited from ISqlDatabaseOptions.) |
|
IsCursorDefaultScopeGlobal | Gets or sets a value that indicates whether the default cursor scope is GLOBAL. (Inherited from ISqlDatabaseOptions.) |
|
IsDateCorrelationOptimizationOn | Gets or sets a value that models the DATE_CORRELATION_OPTIMIZATION option. (Inherited from ISql90DatabaseOptions.) |
|
IsDBChainingOn | Gets or sets a value that indicates whether database chaining is enabled. (Inherited from ISqlDatabaseOptions.) |
|
IsEncryptionOn | Gets or sets a value that indicates whether encryption is enabled. |
|
IsFullTextEnabled | True if full-text support is enabled. (Inherited from ISqlDatabaseOptions.) |
|
IsNumericRoundAbortOn | Gets or sets a value that models the NUMERIC_ROUND_ABORT option. (Inherited from ISqlDatabaseOptions.) |
|
IsOffline | Gets or sets a value that indicates whether the database state is set to OFFLINE. (Inherited from ISqlDatabaseOptions.) |
|
IsQuotedIdentifierOn | Gets or sets a value that models the QUOTED_IDENTIFIER option. (Inherited from ISqlDatabaseOptions.) |
|
IsReadCommittedSnapshot | Gets or sets a value that models the READ_COMMITTED_SNAPSHOT option. (Inherited from ISql90DatabaseOptions.) |
|
IsReadOnly | Gets or sets a value that indicates whether the update state is READ_ONLY. (Inherited from ISqlDatabaseOptions.) |
|
IsRecursiveTriggersOn | Gets or sets a value that indicates whether recursive triggers are enabled. (Inherited from ISqlDatabaseOptions.) |
|
IsSupplementalLoggingOn | Gets or sets a value that indicates whether supplemental logging is enabled. (Inherited from ISql90DatabaseOptions.) |
|
IsTornPageProtectionOn | Reverse compatibility only. Use the PageVerifyMode property instead. (Inherited from ISqlDatabaseOptions.) |
|
IsTrustworthyOn | Gets or sets a value that indicates whether the TRUSTWORTHY setting is enabled. (Inherited from ISql90DatabaseOptions.) |
|
IsVardecimalStorageFormatOn | Gets or sets a value that indicates whether the Vardecimal storage format support is enabled. (Inherited from ISql90DatabaseOptions.) |
|
Model | Gets the model reference. (Inherited from IModelEntity.) |
|
Name | Gets or sets the name of the element. (Inherited from IModelElement.) |
|
PageVerifyMode | Gets or sets a value that models the PAGE_VERIFY option. (Inherited from ISql90DatabaseOptions.) |
|
ParameterizationOption | Gets or sets a value that models the PARAMETERIZATION option. (Inherited from ISql90DatabaseOptions.) |
|
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. (Inherited from ISqlDatabaseOptions.) |
|
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.) |
|
ServiceBrokerOption | Gets or sets a value that models the service broker options. (Inherited from ISql90DatabaseOptions.) |
|
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. (Inherited from ISqlDatabaseOptions.) |
|
ValidationStatus | Gets or sets the value of the model element validation status. (Inherited from IModelElement.) |
|
VarDecimalStorageFormat | Gets or sets a value that indicates whether vardecimal storage is enabled. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
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. (Inherited from ISqlDatabaseOptions.) |
|
GetDefaultFileStreamFilegroupRelationship | Returns an IModelSingleRelationship between this and the ISql100Filegroup. |
|
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