xSQL.Schema.SqlServer Namespace : SqlIndex Class |
For a list of all members of this type, see SqlIndex members.
Name | Description | |
---|---|---|
BucketCount | Gets or sets the bucket count for an hash index. | |
Columns | Gets the collection of columns that participate in the index. (Inherited from xSQL.Schema.SqlServer.IndexBase) | |
ColumnstoreIndexOrderColumns | Returns the collection of columns that appear on the ORDER of a columnstore index. Supported on SQL 2022 or Higher and Azure Databases. | |
CompressionDelay | Gets or sets the compression delay of a columnstore index. | |
DataCompression | Gets or sets the index data compression. (Inherited from xSQL.Schema.SqlServer.IndexBase) | |
FileGroup | Gets or sets the filegroup in which the index is created. | |
FileStreamFileGroup | Gets or sets the filestream filegroup of the index. | |
FileStreamPartitionScheme | Gets or sets the filestream partition schema of the index. | |
FillFactor | Gets or sets the index fill factor. (Inherited from xSQL.Schema.SqlServer.IndexBase) | |
FilterDefinition | Gets or sets the filter definition for the index. | |
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 of the index. The name is formatted as parent_name.index_name. (Inherited from xSQL.Schema.SqlServer.IndexBase) | |
FullyQualifyingNameDelimited | Gets the fully-qualifying name of the index. The name is formatted as [parent_name].[index_name] (Inherited from xSQL.Schema.SqlServer.IndexBase) | |
HasFilter | Gets or sets the value that indicates whether the index has a filter. | |
Id | Gets or sets a unique id for the entity. (Inherited from xSQL.Schema.Core.Entity) | |
IgnoreDuplicateKeys | Gets or sets the value that indicates whether the IGNORE_DUP_KEY property is ON. | |
IsClustered | Gets or sets the value that indicates whether the index is clustered. | |
IsColumnstoreIndex | Gets or sets the value that indicates whether the index is a columnstore index. | |
IsComputed | 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. | |
IsDisabled | Gets or sets the value that indicates whether the index is disabled. | |
IsHashIndex | Gets or sets the value that indicates whether the index is a hash index. | |
IsPadded | Gets or sets the value that indicates whether the PAD_INDEX is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase) | |
IsPageLockEnabled | Gets or sets the value that indicates whether the ALLOW_PAGE_LOCKS is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase) | |
IsPartitioned | Gets or sets the value that indicates whether the index is a partitioned index. | |
IsRowLockEnabled | Gets or sets the value the indicates whether the ALLOW_ROW_LOCKS is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase) | |
IsUnique | Gets or sets the value that indicates whether the index is a unique index. | |
Name | Gets or sets the name of the entity. (Inherited from xSQL.Schema.Core.Entity) | |
NoAutomaticStatsRecompute | Gets or sets the value that indicates whether the STATISTICS_NORECOMPUTE is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase) | |
Parent | Gets the parent entity of this entity. (Inherited from xSQL.Schema.Core.Entity) | |
PartitionColumn | Gets or sets the partition column for the index. | |
PartitionScheme | Gets or sets the partition scheme for the index. | |
Schema | Gets or set the entity schema. (Inherited from xSQL.Schema.Core.Entity) | |
SqlDatabase | Gets the SqlDatabase to which the entity belongs. (Inherited from xSQL.Schema.SqlServer.SqlEntity) | |
SqlEntityType | Gets the type of the entity. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity) | |
SqlExtendedProperties | Gets the collection of extended properties that belong to the index. (Inherited from xSQL.Schema.SqlServer.IndexBase) |