Méthodes Index
SQL Server 2012
Le type Index expose les membres suivants.
| Nom | Description | |
|---|---|---|
|
Alter() | Updates any Index object property changes on the instance of SQL Server. |
|
|
Alter(IndexOperation) | Updates any Index object property changes on the instance of SQL Server for a specified index operation. |
|
|
AlterAllIndexes | Updates any Index object property changes for all indexes on the instance of SQL Server for a specified index operation. |
|
|
CheckIndex | Tests the integrity of database pages that store the index. |
|
|
CheckIndexWithResult | Tests the integrity of database pages that store the index. |
|
|
Create | Creates an index on the instance of SQL Server as defined by the Index object. |
|
|
Disable | Disables the index. |
|
|
Discover | Discovers a list of type Object. (hérité de SqlSmoObject.) |
|
|
Drop | Drops the index. |
|
|
DropAndMove(String) | Drops a clustered index and moves the underlying table data to the specified filegroup. |
|
|
DropAndMove(String, StringCollection) | Drops a clustered index and moves the underlying table data to the partition scheme with the specified partition scheme parameters. |
|
|
Enable | Enables the index. |
|
|
EnumFragmentation() | Enumerates a list of fragmentation information for the index using the default fast fragmentation option. |
|
|
EnumFragmentation(FragmentationOption) | Enumerates a list of fragmentation information for the index with the specified fragmentation option. |
|
|
EnumFragmentation(FragmentationOption, Int32) | Enumerates a list of fragmentation information for the index with the specified fragmentation option and partition number. |
|
|
EnumStatistics | Enumerates a list of statistical information for the index. |
|
|
Equals | (hérité de Object.) |
|
|
FormatSqlVariant | Formats an object as SqlVariant type. (hérité de SqlSmoObject.) |
|
|
GetContextDB | Gets the context database that is associated with this object. (hérité de SqlSmoObject.) |
|
|
GetDBName | Gets the database name that is associated with the object. (hérité de SqlSmoObject.) |
|
|
GetHashCode | (hérité de Object.) |
|
|
GetPropValue | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) |
|
|
GetPropValueOptional | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) |
|
|
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) |
|
|
GetServerObject | Gets the server of the SqlSmoObject object. (hérité de SqlSmoObject.) |
|
|
GetType | (hérité de Object.) |
|
|
Initialize() | Initializes the object and forces the properties be loaded. (hérité de SqlSmoObject.) |
|
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (hérité de SqlSmoObject.) |
|
|
IsObjectInitialized | Verifies whether the object has been initialized. (hérité de SqlSmoObject.) |
|
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (hérité de SqlSmoObject.) |
|
|
MarkForDrop | Marks the index to be dropped the next time that the Alter method is run on the Index object's parent object. |
|
|
Rebuild() | Rebuilds the index. |
|
|
Rebuild(Int32) | Rebuilds the index on the partition with the specified partition number. |
|
|
RebuildAllIndexes | Rebuilds all the indexes. |
|
|
RecalculateSpaceUsage | Updates the disk resource usage of the index. |
|
|
Recreate | Re-creates the index. |
|
|
Refresh | Refreshes the Index object and its properties. (remplace ScriptNameObjectBase.Refresh().) |
|
|
Rename | Renames the index. |
|
|
Reorganize | Reorganizes the index based on current property settings. |
|
|
ReorganizeAllIndexes | Reorganizes all the indexes based on current property settings. |
|
|
Script() | Generates a Transact-SQL script that can be used to re-create the index. |
|
|
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the index as specified by the script options. |
|
|
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (hérité de SqlSmoObject.) |
|
|
ToString | Returns a String that represents the referenced object. (hérité de SqlSmoObject.) |
|
|
UpdateStatistics() | Updates statistics for the referenced index. |
|
|
UpdateStatistics(StatisticsScanType) | Updates statistics for the referenced index with the specified statistics scan type. |
|
|
UpdateStatistics(StatisticsScanType, Int32) | Updates statistics for the referenced index with the specified statistics scan type and specified sample size. |
|
|
UpdateStatistics(StatisticsScanType, Int32, Boolean) | Updates statistics for the referenced index with the specified statistics scan type and specified sample size and with the option to recompute the statistics. |
|
|
Validate | Validates the state of an object. (hérité de SmoObjectBase.) |
| Nom | Description | |
|---|---|---|
|
|
IAlienObject.Discover | Discovers any dependencies. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) |
|
|
IAlienObject.GetDomainRoot | Returns the root of the domain. (hérité de SqlSmoObject.) |
|
|
IAlienObject.GetParent | Gets the parent of this object. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) |
|
|
IAlienObject.GetPropertyType | Gets the type of the specified property. (hérité de SqlSmoObject.) |
|
|
IAlienObject.GetPropertyValue | Gets the value of the specified property. (hérité de SqlSmoObject.) |
|
|
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) |
|
|
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (hérité de SqlSmoObject.) |
|
|
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (hérité de SqlSmoObject.) |
|
|
IAlienObject.SetPropertyValue | Sets the property value. (hérité de SqlSmoObject.) |
|
|
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (hérité de SqlSmoObject.) |
