xSQL Schema Compare SDK for SQL Server version 12
SqlDatabasePropertySet Class Members
| xSQL.Schema.SqlServer Namespace : SqlDatabasePropertySet Class |
The following tables list the members exposed by SqlDatabasePropertySet.
| Name | Description | |
|---|---|---|
 | ChangedTrackingRetentionPeriod | Gets or sets the change tracking retention period. |
| ChangedTrackingRetentionPeriodUnit | Gets or sets the change tracking retention period type. |
| Collation | Gets or sets the database collation. |
| Compatibility | Gets or sets the value that indicates the database compatibility level. |
| FullName | 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) |
| FullNameDelimited | Gets the delimited full name for the entity formatted as [schema].[name]. (Inherited from xSQL.Schema.SqlServer.SqlEntity) |
| FullyQualifyingName | Gets the fully-qualifying name for the entity. (Inherited from xSQL.Schema.SqlServer.SqlEntity) |
| FullyQualifyingNameDelimited | Gets the fully-qualifying name for the entity with delimiters. (Inherited from xSQL.Schema.SqlServer.SqlEntity) |
| Id | Gets or sets a unique id for the entity. (Inherited from xSQL.Schema.Core.Entity) |
| IsAnsiNullDefaultOn | Gets or sets the value that indicates whether ANSI_NULL_DEFAULT is ON. |
| IsAnsiNullsOn | Gets or sets the value that indicates whether ANSI_NULLS is ON. |
| IsAnsiPaddingOn | Gets or sets the value that indicates whether ANSI_PADDING is ON. |
| IsAnsiWarningsOn | Gets or sets the value that indicates whether ANSI_WARNINGS is ON. |
| IsArithmeticAbortOn | Gets or sets the value that indicates whether ARITHABORT is ON. |
| IsAutoCloseOn | Gets or sets the value that indicates whether AUTO_CLOSE is ON. |
| IsAutoCreateStatsOn | Gets or sets the value that indicates whether AUTO_CREATE_STATISTICS is ON. |
| IsAutoShrinkOn | Gets or sets the value that indicates whether AUTO_SHRINK is ON. |
| IsAutoUpdateStatsAsyncOn | Gets or sets the value that indicates whether AUTO_UPDATE_STATISTICS_ASYNC is ON. |
| IsAutoUpdateStatsOn | Gets or sets the value that indicates whether AUTO_UPDATE_STATISTICS is ON. |
| IsBrokerEnabled | Gets or sets the value that indicates whether the database service broker is enabled. |
| IsCaseSensitive | Gets or sets the value that indicates whether the database is case-sensitive. |
| IsChangeDataCaptureEnabled | Gets or sets the value that indicates whether the database change data capture is enabled. |
| IsChangedTrackingAutoCleanupEnabled | Gets or sets the value that indicates whether the change tracking AUTO_CLEANUP is ON. |
| IsChangedTrackingEnabled | Gets or sets the value that indicates whether CHANGE_TRACKING is ON. |
| IsCloseCursorOnCommitOn | Gets or sets the value that indicates whether CURSOR_CLOSE_ON_COMMIT is ON. |
| IsConcatNullsYieldsNullOn | Gets or sets the value that indicates whether CONCAT_NULL_YIELDS_NULL is ON. |
| IsDateCorrelationOn | Gets or sets the value that indicates whether DATE_CORRELATION_OPTIMIZATION is ON. |
| IsDbChainingOn | Gets or sets the value that indicates whether DB_CHAINING is ON. |
| IsEncrypted | Gets or sets the value that indicates whether the database ENCRYPTION is ON. |
| IsFullTextEnabled | Gets or sets the value that indicates whether the full-text search is enabled in the database. |
| IsHonorBrokerPriorityEnabled | Gets or sets the value that indicates whether HONOR_BROKER_PRIORITY is ON. |
| IsInStandby | Gets or sets the value that indicates whether the database is in standby mode. |
| IsLocalCursorDefault | Gets or sets the value that indicates whether CURSOR_DEFAULT is set to LOCAL. |
| IsNumericRoundAbortOn | Gets or sets the value that indicates whether NUMERIC_ROUNDABORT is ON. |
| IsParametrizationForcedOn | Gets or sets the value that indicates whether PARAMETERIZATION is set to FORCED. |
| IsQuotedIdentifierOn | Gets or sets the value that indicates whether QUOTED_IDENTIFIER is ON. |
| IsReadCommittedSnapshotOn | Gets or sets the value that indicates whether READ_COMMITTED_SNAPSHOT is ON. |
| IsReadOnly | Gets or sets the value that indicates whether the database updatability is set to READ_ONLY. |
| IsRecursiveTriggerOn | Gets or sets the value that indicates whether RECURSIVE_TRIGGERS is ON. |
| IsRemoteDataArchivingEnabled | Gets or sets the value that indicates whether the database is stretched. |
| IsSnapshot | Gets or sets the value that indicates whether the database is a snapshot database. |
| IsTrustworthy | Gets or sets the value that indicates whether TRUSTWORTHY is ON. |
| Name | Gets or sets the name of the entity. (Inherited from xSQL.Schema.Core.Entity) |
| PageVerification | Gets or sets the value that indicates the database page-verification type. |
| Parent | Gets the parent entity of this entity. (Inherited from xSQL.Schema.Core.Entity) |
| PartiallyInitialized | Gets or sets the value that indicates whether the database properties are partially initialized due to permission restrictions. |
| RecoveryModel | Gets or sets the value that indicates the database recovery model. |
| Schema | Gets or set the entity schema. (Inherited from xSQL.Schema.Core.Entity) |
| SnapshotIsolationState | Gets or sets the database snapshot isolation state. |
| SqlDatabase | Gets the SqlEntity.SqlDatabase to which the entity belongs. (Inherited from xSQL.Schema.SqlServer.SqlEntity) |
| State | Gets or sets the value that indicates the type of the database state. |
| UserAccess | Gets or sets the value that indicates the database user-access mode. |
| Name | Description | |
|---|---|---|
 | Equals | Overloaded. Returns true if this instance of the SqlEntity class is equal to the other object, which should also be an instance of SqlEntity class. (Inherited from xSQL.Schema.SqlServer.SqlEntity) |
| ToString | Returns the full name of the entity. (Inherited from xSQL.Schema.Core.Entity) |