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


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

Public Properties
 NameDescription
Public PropertyBucketCount Gets or sets the bucket count for an hash index.  
Public PropertyColumns Gets the collection of columns that participate in the index. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyColumnstoreIndexOrderColumns Returns the collection of columns that appear on the ORDER of a columnstore index. Supported on SQL 2022 or Higher and Azure Databases.  
Public PropertyCompressionDelay Gets or sets the compression delay of a columnstore index.  
Public PropertyDataCompression Gets or sets the index data compression. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyFileGroup Gets or sets the filegroup in which the index is created.  
Public PropertyFileStreamFileGroup Gets or sets the filestream filegroup of the index.  
Public PropertyFileStreamPartitionScheme Gets or sets the filestream partition schema of the index.  
Public PropertyFillFactor Gets or sets the index fill factor. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyFilterDefinition Gets or sets the filter definition for the index.  
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 of the index. The name is formatted as parent_name.index_name. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyFullyQualifyingNameDelimited Gets the fully-qualifying name of the index. The name is formatted as [parent_name].[index_name] (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyHasFilter Gets or sets the value that indicates whether the index has a filter.  
Public PropertyId Gets or sets a unique id for the entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyIgnoreDuplicateKeys Gets or sets the value that indicates whether the IGNORE_DUP_KEY property is ON.  
Public PropertyIsClustered Gets or sets the value that indicates whether the index is clustered.  
Public PropertyIsColumnstoreIndex Gets or sets the value that indicates whether the index is a columnstore index.  
Public PropertyIsComputed Gets or sets the value that indicates whether the index is a computed index. The index is considered computed when at least one of the columns that participate in the index is computed.  
Public PropertyIsDisabled Gets or sets the value that indicates whether the index is disabled.  
Public PropertyIsHashIndex Gets or sets the value that indicates whether the index is a hash index.  
Public PropertyIsPadded Gets or sets the value that indicates whether the PAD_INDEX is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyIsPageLockEnabled Gets or sets the value that indicates whether the ALLOW_PAGE_LOCKS is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyIsPartitioned Gets or sets the value that indicates whether the index is a partitioned index.  
Public PropertyIsRowLockEnabled Gets or sets the value the indicates whether the ALLOW_ROW_LOCKS is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyIsUnique Gets or sets the value that indicates whether the index is a unique index.  
Public PropertyName Gets or sets the name of the entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyNoAutomaticStatsRecompute Gets or sets the value that indicates whether the STATISTICS_NORECOMPUTE is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyParent Gets the parent entity of this entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyPartitionColumn Gets or sets the partition column for the index.  
Public PropertyPartitionScheme Gets or sets the partition scheme for the index.  
Public PropertySchema Gets or set the entity schema. (Inherited from xSQL.Schema.Core.Entity)
Public PropertySqlDatabaseGets the SqlDatabase to which the entity belongs. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertySqlEntityType Gets the type of the entity. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity)
Public PropertySqlExtendedProperties Gets the collection of extended properties that belong to the index. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Top
See Also

Reference

SqlIndex Class
xSQL.Schema.SqlServer Namespace

 

 


©Copyright 2022 xSQL Software. All Rights Reserved.

Send Feedback