This documentation is archived and is not being maintained.

Index Properties

(see also Protected Properties )
  Name Description
ms219704.pubproperty(en-US,SQL.90).gif CompactLargeObjects
Gets or sets the Boolean property value that specifies whether to compact the large object (LOB) data in the index.
ms219704.pubproperty(en-US,SQL.90).gif DisallowPageLocks
Gets or sets the Boolean property value that specifies whether the index allows page locks.
ms219704.pubproperty(en-US,SQL.90).gif DisallowRowLocks
Gets or sets the Boolean property value that specifies whether the index allows row locks.
ms219704.pubproperty(en-US,SQL.90).gif Events
Gets the index events supported by the Index object.
ms219704.pubproperty(en-US,SQL.90).gif ExtendedProperties
Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the Index object.
ms219704.pubproperty(en-US,SQL.90).gif FileGroup
Gets or sets the filegroup where the index pages are stored.
ms219704.pubproperty(en-US,SQL.90).gif FillFactor
Gets or sets the percentage of an index page to fill when the index is created or re-created.
ms219704.pubproperty(en-US,SQL.90).gif ID
Gets the index ID value that uniquely identifies the index within the database.
ms219704.pubproperty(en-US,SQL.90).gif IgnoreDuplicateKeys
Gets or sets the Boolean property value that specifies whether the index ignores duplicate keys.
ms219704.pubproperty(en-US,SQL.90).gif IndexedColumns
Gets a collection of IndexedColumn objects that represent all the columns participating in the index.
ms219704.pubproperty(en-US,SQL.90).gif IndexKeyType
Gets or sets the index key type.
ms219704.pubproperty(en-US,SQL.90).gif IsClustered
Gets or sets the Boolean property value that specifies whether the index is clustered.
ms219704.pubproperty(en-US,SQL.90).gif IsDisabled
Gets or sets the Boolean property value that specifies whether the index is disabled.
ms219704.pubproperty(en-US,SQL.90).gif IsFullTextKey
Gets or sets the Boolean value that specifies whether the index is enabled for row identification in Microsoft Search.
ms219704.pubproperty(en-US,SQL.90).gif IsIndexOnComputed
Gets the Boolean property value that specifies whether the index is based on a computed column.
ms219704.pubproperty(en-US,SQL.90).gif IsIndexOnTable
Gets the Boolean property value that specifies whether the index is defined for a table or a view.
ms219704.pubproperty(en-US,SQL.90).gif IsPartitioned
Gets the Boolean property value that specifies whether the index is stored in a partitioned scheme.
ms219704.pubproperty(en-US,SQL.90).gif IsSystemNamed
Gets the Boolean property value that specifies whether the index was named automatically by the system.
ms219704.pubproperty(en-US,SQL.90).gif IsSystemObject
Gets the Boolean property value that specifies whether the index is a system object.
ms219704.pubproperty(en-US,SQL.90).gif IsUnique
Gets or sets the Boolean property value that specifies whether the index is unique or not.
ms219704.pubproperty(en-US,SQL.90).gif IsXmlIndex
Gets or sets the Boolean property value that specifies whether the index is an XML index.
ms219704.pubproperty(en-US,SQL.90).gif MaximumDegreeOfParallelism
Gets or sets the maximum number of processors that can be used when running a query that uses the index.
ms219704.pubproperty(en-US,SQL.90).gif Name 
Gets or sets the name of the object.
(inherited from NamedSmoObject )
ms219704.pubproperty(en-US,SQL.90).gif NoAutomaticRecomputation
Gets or sets the Boolean property value that specifies whether statistics are regenerated when an index is created.
ms219704.pubproperty(en-US,SQL.90).gif 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.
ms219704.pubproperty(en-US,SQL.90).gif 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.
ms219704.pubproperty(en-US,SQL.90).gif Parent
Gets or sets the SqlSmoObject object that is the parent of the Index object.
ms219704.pubproperty(en-US,SQL.90).gif ParentXmlIndex
Gets or sets the parent of an XML index.
ms219704.pubproperty(en-US,SQL.90).gif PartitionScheme
Gets or sets the partition scheme associated with the index.
ms219704.pubproperty(en-US,SQL.90).gif PartitionSchemeParameters
Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a parameter in the partition scheme associated with the index.
ms219704.pubproperty(en-US,SQL.90).gif Properties 
Gets a collection of Property objects that represent the object properties.
(inherited from SqlSmoObject )
ms219704.pubproperty(en-US,SQL.90).gif SecondaryXmlIndexType
Gets or sets the secondary XML index type.
ms219704.pubproperty(en-US,SQL.90).gif SortInTempdb
Gets or sets the Boolean property value that specifies whether the index is sorted using the tempdb database for intermediate storage of data.
ms219704.pubproperty(en-US,SQL.90).gif SpaceUsed
Gets or sets the disk space used to store the index data in kilobytes.
ms219704.pubproperty(en-US,SQL.90).gif State 
Gets the state of the referenced object.
(inherited from SmoObjectBase )
ms219704.pubproperty(en-US,SQL.90).gif Urn 
Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.
(inherited from SqlSmoObject )
ms219704.pubproperty(en-US,SQL.90).gif UserData 
Gets or sets user-defined data associated with the referenced object.
(inherited from SmoObjectBase )

  Name Description
ms219704.protproperty(en-US,SQL.90).gif ExecuteForScalar 
Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option.
(inherited from SqlSmoObject )
ms219704.protproperty(en-US,SQL.90).gif ObjectInSpace 
Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly.
(inherited from SqlSmoObject )
ms219704.protproperty(en-US,SQL.90).gif PresetProperties 
Gets or sets the preset properties of the referenced object.
(inherited from SqlSmoObject )
ms219704.protproperty(en-US,SQL.90).gif ScalarResult 
Gets the scalar result for the referenced object.
(inherited from SqlSmoObject )
Show: