Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Index Properties

The Index type exposes the following members.

  Name Description
Public property BoundingBoxXMax Specifies the x-coordinate of the upper right corner of a bounding box.
Public property BoundingBoxXMin Specifies the x-coordinate of the lower-left corner of a bounding box.
Public property BoundingBoxYMax Specifies the y-coordinate of upper-right corner of a bounding box.
Public property BoundingBoxYMin Specifies the y-coordinate of the lower-left corner of a bounding box.
Public property CellsPerObject Defines the maximum number of cells that tessellation can count per object.
Public property CompactLargeObjects Gets or sets the Boolean property value that specifies whether to compact the large object (LOB) data in the index.
Public property DisallowPageLocks Gets or sets the Boolean property value that specifies whether the index allows page locks.
Public property DisallowRowLocks Gets or sets the Boolean property value that specifies whether the index allows row locks.
Public property Events Gets the index events supported by the Index object.
Public property ExtendedProperties Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the Index object.
Public property FileGroup Gets or sets the filegroup where the index pages are stored.
Public property FileStreamFileGroup Gets or Sets the file group name for the index.
Public property FileStreamPartitionScheme Gets or Sets the partition scheme name for the index.
Public property FillFactor Gets or sets the percentage of an index page to fill when the index is created or re-created.
Public property FilterDefinition Gets or sets the String value that contains the definition for the filter.
Public property HasCompressedPartitions Gets or sets the Boolean property value that specifies whether the index has compressed partitions.
Public property HasFilter Gets the Boolean property value that specifies whether the index has a filter defined for a range of index values.
Public property ID Gets the index ID value that uniquely identifies the index within the database.
Public property IgnoreDuplicateKeys Gets or sets the Boolean property value that specifies whether the index ignores duplicate keys.
Public property IndexedColumns Gets a collection of IndexedColumn objects that represent all the columns participating in the index.
Public property IndexedXmlPathName Gets or sets the name of the indexed XML path.
Public property IndexedXmlPathNamespaces Gets the collection of indexed XML path namespace.
Public property IndexedXmlPaths Gets or sets the collection of indexed XML paths.
Public property IndexKeyType Gets or sets the index key type.
Public property IndexType Gets or sets the type of index.
Public property IsClustered Gets or sets the Boolean property value that specifies whether the index is clustered.
Public property IsDisabled Gets or sets the Boolean property value that specifies whether the index is disabled.
Public property IsFileTableDefined Gets or sets whether the file table is defined.
Public property IsFullTextKey Gets the Boolean value that specifies whether the index is enabled for row identification in Microsoft Search.
Public property IsIndexOnComputed Gets the Boolean property value that specifies whether the index is based on a computed column.
Public property IsIndexOnTable Gets the Boolean property value that specifies whether the index is defined for a table or a view.
Public property IsPartitioned Gets the Boolean property value that specifies whether the index is stored in a partitioned scheme.
Public property IsSpatialIndex Gets a value that indicates whether an index is a spatial index.
Public property IsSystemNamed Gets the Boolean property value that specifies whether the index was named automatically by the system.
Public property IsSystemObject Gets the Boolean property value that specifies whether the index is a system object.
Public property IsUnique Gets or sets the Boolean property value that specifies whether the index is unique or not.
Public property IsXmlIndex Gets or sets the Boolean property value that specifies whether the index is an XML index.
Public property Level1Grid Gets or sets the first level of decomposition for a geometry data type.
Public property Level2Grid Specifies the second level of decomposition for a geometry data type.
Public property Level3Grid Specifies the third level of decomposition for a geometry data type.
Public property Level4Grid Gets or sets the fourth level of decomposition for a geometry data type.
Public property MaximumDegreeOfParallelism Gets or sets the maximum number of processors that can be used when running a query that uses the index.
Public property Name Gets or sets the name of the index. (Overrides NamedSmoObject.Name.)
Public property NoAutomaticRecomputation Gets or sets the Boolean property value that specifies whether statistics are regenerated when an index is created.
Public property OnlineIndexOperation 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.
Public property PadIndex Gets or sets the Boolean property value that specifies whether space is left open on each page of the intermediate levels of the index.
Public property Parent Gets or sets the SqlSmoObject object that is the parent of the Index object.
Public property ParentXmlIndex Gets or sets the parent of an XML index.
Public property PartitionScheme Gets or sets the partition scheme associated with the index.
Public property PartitionSchemeParameters Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a parameter in the partition scheme associated with the index.
Public property PhysicalPartitions Gets a collection of PhysicalPartition objects that represent all the physical partitions on which the index is stored.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property SecondaryXmlIndexType Gets or sets the secondary XML index type.
Public property SortInTempdb Gets or sets the Boolean property value that specifies whether the index is sorted using the tempdb database for intermediate storage of data.
Public property SpaceUsed Gets or sets the disk space used to store the index data in kilobytes.
Public property SpatialIndexType Gets or sets the Spatial Index Type for a column.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top
  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets a Boolean value that indicates whether the object supports design mode.
Top
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.