Index Methods

Public Methods

(see also Protected Methods )

  Name Description
ms219636.pubmethod(en-US,SQL.90).gif Alter Overloaded.
Updates any Index object property changes on the instance of Microsoft SQL Server.
ms219636.pubmethod(en-US,SQL.90).gif AlterAllIndexes
Updates any Index object property changes for all indexes on the instance of Microsoft SQL Server for a specified index operation.
ms219636.pubmethod(en-US,SQL.90).gif CheckIndex
Tests the integrity of database pages that store the index.
ms219636.pubmethod(en-US,SQL.90).gif CheckIndexWithResult
Tests the integrity of database pages that store the index.
ms219636.pubmethod(en-US,SQL.90).gif Create
Creates an index on the instance of Microsoft SQL Server as defined by the Index object.
ms219636.pubmethod(en-US,SQL.90).gif Disable
Disables the index.
ms219636.pubmethod(en-US,SQL.90).gif Drop
Drops the index.
ms219636.pubmethod(en-US,SQL.90).gif DropAndMove Overloaded.
Drops the index and re-creates the index in a specified filegroup.
ms219636.pubmethod(en-US,SQL.90).gif Enable
Enables the index.
ms219636.pubmethod(en-US,SQL.90).gif EnumFragmentation Overloaded.
Enumerates a list of fragmentation information for the index using the fast fragmentation option.
ms219636.pubmethod(en-US,SQL.90).gif EnumStatistics
Enumerates a list of statistical information for the index.
ms219636.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219636.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms219636.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219636.pubmethod(en-US,SQL.90).gif Initialize  Overloaded.
Initializes the object and forces the properties be loaded.
(inherited from SqlSmoObject )
ms219636.pubmethod(en-US,SQL.90).gif MarkForDrop
Marks the index to be dropped the next time that the Alter method is run on the Index object's parent object.
ms219636.pubmethod(en-US,SQL.90).gif Rebuild
Rebuilds the index.
ms219636.pubmethod(en-US,SQL.90).gif RebuildAllIndexes
Rebuilds all the indexes.
ms219636.pubmethod(en-US,SQL.90).gif RecalculateSpaceUsage
Updates the disk resource usage of the index.
ms219636.pubmethod(en-US,SQL.90).gif Recreate
Re-creates the index.
ms219636.pubmethod(en-US,SQL.90).gifms219636.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219636.pubmethod(en-US,SQL.90).gif Refresh Overridden.
Refreshes the Index object and its properties.
ms219636.pubmethod(en-US,SQL.90).gif Rename
Renames the index.
ms219636.pubmethod(en-US,SQL.90).gif Reorganize
Reorganizes the index based on current property settings.
ms219636.pubmethod(en-US,SQL.90).gif ReorganizeAllIndexes
Reorganizes all the indexes based on current property settings.
ms219636.pubmethod(en-US,SQL.90).gif Script Overloaded.
Generates a Transact-SQL script that can be used to re-create the index.
ms219636.pubmethod(en-US,SQL.90).gif ToString 
Returns a String that represents the referenced object.
(inherited from SqlSmoObject )
ms219636.pubmethod(en-US,SQL.90).gif UpdateStatistics Overloaded.
Updates the statistics for the referenced index.

Protected Methods

  Name Description
ms219636.protmethod(en-US,SQL.90).gif AlterImpl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif AlterImplFinish  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif AlterImplInit  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif AlterImplWorker  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif AppendCommaText  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif AppendWithCommaText  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif AppendWithOption  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif BindDefaultImpl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif BindRuleImpl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif CheckCollation  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif CheckObjectState  Overloaded.
Validates the state of the referenced object.
(inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif CheckObjectStateImpl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif CheckTextCorectness  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif CheckTextModeSupport  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif CheckVersion80 
Checks the validity of the object on Microsoft SQL Server 2000.
(inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif CheckVersion80SP3 
Checks the validity of the object on Microsoft SQL Server 2000 SP3.
(inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif CheckVersion90 
Check the validity of the object on Microsoft SQL Server 2005.
(inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif CheckVersionBelow90  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif CleanObject 
Cleans the referenced object.
(inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif CreateImpl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif CreateImplFinish  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif CreateImplInit  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif DropImpl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif DropImplWorker  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219636.protmethod(en-US,SQL.90).gif ForceTextModeOnTextBody 
Enforces text mode on the text body.
(inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif FormatSqlVariant  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GenerateDataSpaceScript  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetBindDefaultScript  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetBindRuleScript  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetBoolParameter  Overloaded. (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetBraketNameForText  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif GetDateTimeParameter  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetDateTimeParameterAsInt  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetDBName 
Gets the database name associated with the object.
(inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetEnumParameter  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetFragOptionString  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetGuidParameter  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetIsTextDirty 
Determines whether the text value is consistent with stored value.
(inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif GetParameter  Overloaded. (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetPropValue  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetPropValueOptional  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetPropValueOptionalAllowNull  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetRealValue  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetScriptIncludeExists  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif GetScriptingOptionsForCreate  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetServerName 
Gets the name of the instance of Microsoft SQL Server with which the object is associated.
(inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetSqlServerVersionName 
Gets the version name of the instance of Microsoft SQL Server with which the object is associated.
(inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetStringParameter  Overloaded. (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetTextBody  Overloaded.
Returns the text body.
(inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif GetTextForScript  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif GetTextHeader  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif GetTextMode 
Determines whether the script name is using text mode.
(inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif GetTextProperty  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif GetTimeSpanParameterAsInt  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif GetUrnRecursive  Overloaded. (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif ImplInitialize  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gifms219636.static(en-US,SQL.90).gif IsCollectionDirty  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif IsObjectDirty 
Determines whether the referenced object is consistent with the stored object.
(inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif IsObjectInitialized 
Verifies whether the object has been initialized.
(inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif IsObjectInSpace 
Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server.
(inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif IsVersion80SP3  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif MarkDropped  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif MarkForDropImpl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms219636.protmethod(en-US,SQL.90).gif PostAlter  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif PostCreate  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif PostDrop  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif RenameImpl  (inherited from NamedSmoObject )
ms219636.protmethod(en-US,SQL.90).gif RenameImplWorker  (inherited from NamedSmoObject )
ms219636.protmethod(en-US,SQL.90).gif ScriptAlter  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif ScriptAnsiQI  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif ScriptChangeOwner  (inherited from NamedSmoObject )
ms219636.protmethod(en-US,SQL.90).gif ScriptCreate  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif ScriptDdl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif ScriptDrop  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif ScriptImpl  Overloaded. (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif ScriptImplWorker  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif ScriptInformativeHeaders  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif ScriptRename  (inherited from NamedSmoObject )
ms219636.protmethod(en-US,SQL.90).gif SetCollectionTextMode  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif SetParentImpl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif SetTextBody  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif SetTextHeader  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif SetTextMode  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif SwitchTextMode  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gif ThrowIfTextIsDirtyForAlter  (inherited from ScriptNameObjectBase )
ms219636.protmethod(en-US,SQL.90).gifms219636.static(en-US,SQL.90).gif Trace  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif UnbindDefaultImpl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gif UnbindRuleImpl  (inherited from SqlSmoObject )
ms219636.protmethod(en-US,SQL.90).gifms219636.static(en-US,SQL.90).gif UpdateCollectionState2  (inherited from SqlSmoObject )

See Also

Reference

Index Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Creating, Altering, and Removing Indexes
Indexes
CREATE INDEX (Transact-SQL)