xSQL Schema Compare SDK version 9.5 for SQL Server
SqlDatabasePropertySet Class Properties


For a list of all members of this type, see SqlDatabasePropertySet members.

Public Properties
 NameDescription
Public PropertyChangedTrackingRetentionPeriod Gets or sets the change tracking retention period.  
Public PropertyChangedTrackingRetentionPeriodUnit Gets or sets the change tracking retention period type.  
Public PropertyCollation Gets or sets the database collation.  
Public PropertyCompatibility Gets or sets the value that indicates the database compatibility level.  
Public PropertyFullName Gets the full name of the entity formatted as schema.name. If the entity has no schema, only the name is returned. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyFullNameDelimited Gets the delimited full name for the entity formatted as [schema].[name]. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyFullyQualifyingName Gets the fully-qualifying name for the entity. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyFullyQualifyingNameDelimited Gets the fully-qualifying name for the entity with delimiters. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyId Gets or sets a unique id for the entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyIsAnsiNullDefaultOn Gets or sets the value that indicates whether ANSI_NULL_DEFAULT is ON.  
Public PropertyIsAnsiNullsOn Gets or sets the value that indicates whether ANSI_NULLS is ON.  
Public PropertyIsAnsiPaddingOn Gets or sets the value that indicates whether ANSI_PADDING is ON.  
Public PropertyIsAnsiWarningsOn Gets or sets the value that indicates whether ANSI_WARNINGS is ON.  
Public PropertyIsArithmeticAbortOn Gets or sets the value that indicates whether ARITHABORT is ON.  
Public PropertyIsAutoCloseOn Gets or sets the value that indicates whether AUTO_CLOSE is ON.  
Public PropertyIsAutoCreateStatsOn Gets or sets the value that indicates whether AUTO_CREATE_STATISTICS is ON.  
Public PropertyIsAutoShrinkOn Gets or sets the value that indicates whether AUTO_SHRINK is ON.  
Public PropertyIsAutoUpdateStatsAsyncOn Gets or sets the value that indicates whether AUTO_UPDATE_STATISTICS_ASYNC is ON.  
Public PropertyIsAutoUpdateStatsOn Gets or sets the value that indicates whether AUTO_UPDATE_STATISTICS is ON.  
Public PropertyIsBrokerEnabled Gets or sets the value that indicates whether the database service broker is enabled.  
Public PropertyIsCaseSensitive Gets or sets the value that indicates whether the database is case-sensitive.  
Public PropertyIsChangeDataCaptureEnabled Gets or sets the value that indicates whether the database change data capture is enabled.  
Public PropertyIsChangedTrackingAutoCleanupEnabled Gets or sets the value that indicates whether the change tracking AUTO_CLEANUP is ON.  
Public PropertyIsChangedTrackingEnabled Gets or sets the value that indicates whether CHANGE_TRACKING is ON.  
Public PropertyIsCloseCursorOnCommitOn Gets or sets the value that indicates whether CURSOR_CLOSE_ON_COMMIT is ON.  
Public PropertyIsConcatNullsYieldsNullOn Gets or sets the value that indicates whether CONCAT_NULL_YIELDS_NULL is ON.  
Public PropertyIsDateCorrelationOn Gets or sets the value that indicates whether DATE_CORRELATION_OPTIMIZATION is ON.  
Public PropertyIsDbChainingOn Gets or sets the value that indicates whether DB_CHAINING is ON.  
Public PropertyIsEncrypted Gets or sets the value that indicates whether the database ENCRYPTION is ON.  
Public PropertyIsFullTextEnabled Gets or sets the value that indicates whether the full-text search is enabled in the database.  
Public PropertyIsHonorBrokerPriorityEnabled Gets or sets the value that indicates whether HONOR_BROKER_PRIORITY is ON.  
Public PropertyIsInStandby Gets or sets the value that indicates whether the database is in standby mode.  
Public PropertyIsLocalCursorDefault Gets or sets the value that indicates whether CURSOR_DEFAULT is set to LOCAL.  
Public PropertyIsNumericRoundAbortOn Gets or sets the value that indicates whether NUMERIC_ROUNDABORT is ON.  
Public PropertyIsParametrizationForcedOn Gets or sets the value that indicates whether PARAMETERIZATION is set to FORCED.  
Public PropertyIsQuotedIdentifierOn Gets or sets the value that indicates whether QUOTED_IDENTIFIER is ON.  
Public PropertyIsReadCommittedSnapshotOn Gets or sets the value that indicates whether READ_COMMITTED_SNAPSHOT is ON.  
Public PropertyIsReadOnly Gets or sets the value that indicates whether the database updatability is set to READ_ONLY.  
Public PropertyIsRecursiveTriggerOn Gets or sets the value that indicates whether RECURSIVE_TRIGGERS is ON.  
Public PropertyIsRemoteDataArchivingEnabled Gets or sets the value that indicates whether the database is stretched.  
Public PropertyIsSnapshot Gets or sets the value that indicates whether the database is a snapshot database.  
Public PropertyIsTrustworthy Gets or sets the value that indicates whether TRUSTWORTHY is ON.  
Public PropertyName Gets or sets the name of the entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyPageVerification Gets or sets the value that indicates the database page-verification type.  
Public PropertyParent Gets the parent entity of this entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyPartiallyInitialized Gets or sets the value that indicates whether the database properties are partially initialized due to permission restrictions.  
Public PropertyRecoveryModel Gets or sets the value that indicates the database recovery model.  
Public PropertySchema Gets or set the entity schema. (Inherited from xSQL.Schema.Core.Entity)
Public PropertySnapshotIsolationState Gets or sets the database snapshot isolation state.  
Public PropertySqlDatabaseGets the SqlEntity.SqlDatabase to which the entity belongs. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyState Gets or sets the value that indicates the type of the database state.  
Public PropertyUserAccess Gets or sets the value that indicates the database user-access mode.  
Top
See Also

Reference

SqlDatabasePropertySet Class
xSQL.Schema.SqlServer Namespace

 

 


┬ęCopyright 2018 xSQL Software. All Rights Reserved.

Send Feedback