xSQL Schema Compare SDK for SQL Server version 12
SchemaOptions Class Properties


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

Public Properties
 NameDescription
Public PropertyCorrectHistoryTableMissingPartitioningIndicates that the partitioning of the history table associated with a system-versioned table should be updated when some of the properties are missing.

In some rare cases, due to a bug in the SQL Server system-versioning, the partitioning column of the history table is not set.

 
Public PropertyReadAggregates Indicates whether the aggregates should be read.  
Public PropertyReadApplicationRoles Indicates whether the application roles should be read.  
Public PropertyReadAssemblies Indicates whether the assemblies should be read.  
Public PropertyReadAsymmetricKeys Indicates whether the asymmetric keys should be read.  
Public PropertyReadBrokerContracts Indicates whether the broker contracts should be read.  
Public PropertyReadBrokerMessageTypes Indicates whether the broker message types should be read.  
Public PropertyReadBrokerPriorities Indicates whether the broker priorities should be read.  
Public PropertyReadBrokerQueues Indicates whether the broker queues should be read.  
Public PropertyReadBrokerRemoteServiceBindings Indicates whether the remote service bindings should be read.  
Public PropertyReadBrokerRoutes Indicates whether the broker routes should be read.  
Public PropertyReadBrokerServices Indicates whether the broker services should be read.  
Public PropertyReadCertificates Indicates whether the certificates should be read.  
Public PropertyReadCheckConstraints Indicates whether the check constraints should be read.  
Public PropertyReadClrTypes Indicates whether the CLR types should be read.  
Public PropertyReadColumnEncryptionKeys Indicates whether the column encryption keys should be read.  
Public PropertyReadColumnMasterKeys Indicates whether the column master keys should be read.  
Public PropertyReadDatabaseRoles Indicates whether the database roles should be read.  
Public PropertyReadDatabaseTriggers Indicates whether the database triggers should be read.  
Public PropertyReadDefaultConstraints Indicates whether the default constraints should be read.  
Public PropertyReadDefaults Indicates whether the defaults should be read.  
Public PropertyReadEdgeConstraints Indicates whether the edge constraints should be read.  
Public PropertyReadExtendedProperties Indicates whether the extended properties should be read.  
Public PropertyReadForeignKeyConstraints Indicates whether the foreign keys should be read.  
Public PropertyReadFullTextCatalogs Indicates whether the full-text catalogs should be read.  
Public PropertyReadFullTextIndexes Indicates whether the full-text indexes should be read.  
Public PropertyReadFullTextStopLists Indicates whether the full-text stop lists should be read.  
Public PropertyReadFullTextStopListWords Indicates whether the keywords associated with the full-text stop lists be read.  
Public PropertyReadFunctions Indicates whether the functions should be read.  
Public PropertyReadGraphTables Indicates whether the graph tables should be read.  
Public PropertyReadIndexes Indicates whether the indexes should be read.  
Public PropertyReadMemoryTables Indicates whether the memory-optimized tables should be read.  
Public PropertyReadPartitionFunctions Indicates whether the partition functions should be read.  
Public PropertyReadPartitionSchemes Indicates whether the partition schemes be read.  
Public PropertyReadPermissions Indicates whether the permissions should be read.  
Public PropertyReadPrimaryKeys Indicates whether the primary keys should be read.  
Public PropertyReadProcedures Indicates whether the procedures should be read.  
Public PropertyReadRules Indicates whether the rules should be read.  
Public PropertyReadSchemas Indicates whether the database schemas should be read.  
Public PropertyReadSearchPropertyLists Indicates whether the search property lists should be read.  
Public PropertyReadSecurityPolicies Indicates whether the security policies should be read.  
Public PropertyReadSequences Indicates whether the sequences should be read.  
Public PropertyReadSpatialIndexes Indicates whether the spatial indexes should be read.  
Public PropertyReadStatistics Indicates whether the statistics should be read.  
Public PropertyReadSymmetricKeys Indicates whether the symmetric keys should be read.  
Public PropertyReadSynonims Indicates whether the synonyms should be read.  
Public PropertyReadTables Indicates whether the tables should be read.  
Public PropertyReadTriggers Indicates whether the trigger schema should be read.  
Public PropertyReadUniqueConstraints Indicates whether the unique constraints should be read.  
Public PropertyReadUserDefinedDataTypes Indicates whether the user-defined data types should be read.  
Public PropertyReadUserDefinedTableTypes Indicates whether the user-defined table types should be read.  
Public PropertyReadUsers Indicates whether the users should be read.  
Public PropertyReadViews Indicates whether the views should be read.  
Public PropertyReadXmlIndexes Indicates whether the xml indexes should be read.  
Public PropertyReadXmlSchemaCollections Indicates whether the xml schema collections be read.  
Top
See Also

Reference

SchemaOptions Class
xSQL.Schema.SqlServer Namespace

 

 


©Copyright 2022 xSQL Software. All Rights Reserved.

Send Feedback