xSQL.Schema.SqlServer Namespace : SqlIndex Class |
The following tables list the members exposed by SqlIndex.
Name | Description | |
---|---|---|
![]() | SqlIndex Constructor | Overloaded. |
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) |
Name | Description | |
---|---|---|
![]() | Equals | Overloaded. Returns true if this instance of the SqlScriptableEntity class is equal to the other object, which should also be an instance of SqlScriptableEntity class. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity) |
![]() | GetScript | Returns the T-SQL script for this entity with the specified scripting options. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity) |
![]() | ToString | Returns the full name of the entity. (Inherited from xSQL.Schema.Core.Entity) |