Export (0) Print
Expand All

Index Properties

 

Applies To: SQL Server 2016 Preview

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyBoundingBoxXMax

Gets or sets the x-coordinate of the upper right corner of a bounding box.

System_CAPS_pubpropertyBoundingBoxXMin

Gets or sets the x-coordinate of the lower-left corner of a bounding box.

System_CAPS_pubpropertyBoundingBoxYMax

Gets or sets the y-coordinate of upper-right corner of a bounding box.

System_CAPS_pubpropertyBoundingBoxYMin

Gets or sets the y-coordinate of the lower-left corner of a bounding box.

System_CAPS_pubpropertyBucketCount

Gets or sets the value of the bucket count for a hash index.

System_CAPS_pubpropertyCellsPerObject

Gets or sets the maximum number of cells that tessellation can count per object.

System_CAPS_pubpropertyCompactLargeObjects

Gets or sets the Boolean property value that specifies whether to compact the large object (LOB) data in the index.

System_CAPS_pubpropertyDisallowPageLocks

Gets or sets the Boolean property value that specifies whether the index allows page locks.

System_CAPS_pubpropertyDisallowRowLocks

Gets or sets the Boolean property value that specifies whether the index allows row locks.

System_CAPS_pubpropertyDistributionColumns

Gets the collection of distribution columns used by the distribution policy on this index.

System_CAPS_pubpropertyDistributionPolicy

Gets or sets the distribution policy that is currently used to distribute the rows of the current Index across the bricks.

System_CAPS_pubpropertyEvents

Gets the index events supported by the Index object.

System_CAPS_pubpropertyExtendedProperties

Gets a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the Index object.

System_CAPS_pubpropertyFileGroup

Gets or sets the filegroup where the index pages are stored.

System_CAPS_pubpropertyFileStreamFileGroup

Gets or Sets the file group name for the index.

System_CAPS_pubpropertyFileStreamPartitionScheme

Gets or Sets the partition scheme name for the index.

System_CAPS_pubpropertyFillFactor

Gets or sets the percentage of an index page to fill when the index is created or re-created.

System_CAPS_pubpropertyFilterDefinition

Gets or sets the String value that contains the definition for the filter.

System_CAPS_pubpropertyHasCompressedPartitions

Gets or sets the Boolean property value that specifies whether the index has compressed partitions.

System_CAPS_pubpropertyHasFilter

Gets the Boolean property value that specifies whether the index has a filter defined for a range of index values.

System_CAPS_pubpropertyID

Gets the index ID value that uniquely identifies the index within the database.

System_CAPS_pubpropertyIgnoreDuplicateKeys

Gets or sets the Boolean property value that specifies whether the index ignores duplicate keys.

System_CAPS_pubpropertyIndexedColumns

Gets a collection of IndexedColumn objects that represent all the columns participating in the index.

System_CAPS_pubpropertyIndexedXmlPathName

Gets or sets the name of the indexed XML path.

System_CAPS_pubpropertyIndexedXmlPathNamespaces

Gets the collection of indexed XML path namespace.

System_CAPS_pubpropertyIndexedXmlPaths

Gets or sets the collection of indexed XML paths.

System_CAPS_pubpropertyIndexKeyType

Gets or sets the index key type.

System_CAPS_pubpropertyIndexType

Gets or sets the type of index.

System_CAPS_pubpropertyIsClustered

Gets or sets the Boolean property value that specifies whether the index is clustered.

System_CAPS_pubpropertyIsDisabled

Gets or sets the Boolean property value that specifies whether the index is disabled.

System_CAPS_pubpropertyIsFileTableDefined

Gets or sets whether the file table is defined.

System_CAPS_pubpropertyIsFullTextKey

Gets the Boolean value that specifies whether the index is enabled for row identification in Microsoft Search.

System_CAPS_pubpropertyIsIndexOnComputed

Gets the Boolean property value that specifies whether the index is based on a computed column.

System_CAPS_pubpropertyIsIndexOnTable

Gets the Boolean property value that specifies whether the index is defined for a table or a view.

System_CAPS_pubpropertyIsMemoryOptimized

Gets or sets the Boolean property value that specifies whether the index is memory optimized.

System_CAPS_pubpropertyIsPartitioned

Gets the Boolean property value that specifies whether the index is stored in a partitioned scheme.

System_CAPS_pubpropertyIsSpatialIndex

Gets a value that indicates whether an index is a spatial index.

System_CAPS_pubpropertyIsSystemNamed

Gets the Boolean property value that specifies whether the index was named automatically by the system.

System_CAPS_pubpropertyIsSystemObject

Gets the Boolean property value that specifies whether the index is a system object.

System_CAPS_pubpropertyIsUnique

Gets or sets the Boolean property value that specifies whether the index is unique or not.

System_CAPS_pubpropertyIsXmlIndex

Gets or sets the Boolean property value that specifies whether the index is an XML index.

System_CAPS_pubpropertyLevel1Grid

Gets or sets the first level of decomposition for a geometry data type.

System_CAPS_pubpropertyLevel2Grid

Gets or sets the second level of decomposition for a geometry data type.

System_CAPS_pubpropertyLevel3Grid

Gets or sets the third level of decomposition for a geometry data type.

System_CAPS_pubpropertyLevel4Grid

Gets or sets the fourth level of decomposition for a geometry data type.

System_CAPS_pubpropertyLowPriorityAbortAfterWait

Gets or sets the action that will be taken after the Low Priority expires during an online index build operation on this index.

System_CAPS_pubpropertyLowPriorityMaxDuration

Gets or sets the amount of time (in minutes) to wait with Low Priority for acquiring the locks required for the online index build operations on this Index.

System_CAPS_pubpropertyMaximumDegreeOfParallelism

Gets or sets the maximum number of processors that can be used when running a query that uses the index.

System_CAPS_pubpropertyName

Gets or sets the name of the index.(Overrides NamedSmoObject.Name.)

System_CAPS_pubpropertyNoAutomaticRecomputation

Gets or sets the Boolean property value that specifies whether statistics are regenerated when an index is created.

System_CAPS_pubpropertyOnlineIndexOperation

Gets or sets the Boolean property value that specifies whether the index will be kept online during index operations thus allowing access to the data.

System_CAPS_pubpropertyPadIndex

Gets or sets the Boolean property value that specifies whether space is left open on each page of the intermediate levels of the index.

System_CAPS_pubpropertyParent

Gets or sets the SqlSmoObject object that is the parent of the Index object.

System_CAPS_pubpropertyParentXmlIndex

Gets or sets the parent of an XML index.

System_CAPS_pubpropertyPartitionScheme

Gets or sets the partition scheme associated with the index.

System_CAPS_pubpropertyPartitionSchemeParameters

Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a parameter in the partition scheme associated with the index.

System_CAPS_pubpropertyPhysicalPartitions

Gets a collection of PhysicalPartition objects that represent all the physical partitions on which the index is stored.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertySecondaryXmlIndexType

Gets or sets the secondary XML index type.

System_CAPS_pubpropertySortInTempdb

Gets or sets the Boolean property value that specifies whether the index is sorted using the tempdb database for intermediate storage of data.

System_CAPS_pubpropertySpaceUsed

Gets or sets the disk space used to store the index data in kilobytes.

System_CAPS_pubpropertySpatialIndexType

Gets or sets the Spatial Index Type for a column.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft