共用方式為


Index 成員

The Index object represents a SQL Server index.

Index 型別公開下列成員。

建構函式

  名稱 描述
公用方法 Index() () () () Initializes a new instance of the Index class.
公用方法 Index(SqlSmoObject, String) Initializes a new instance of the Index class on the specified parent object and with the specified name.

頂端

方法

  名稱 描述
受保護的方法 AddDatabaseContext (繼承自 SqlSmoObject。)
公用方法 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.
受保護的方法 AlterImpl (繼承自 SqlSmoObject。)
受保護的方法 AlterImplFinish (繼承自 SqlSmoObject。)
受保護的方法 AlterImplInit (繼承自 SqlSmoObject。)
受保護的方法 AlterImplWorker (繼承自 SqlSmoObject。)
受保護的方法 AppendCommaText (繼承自 ScriptNameObjectBase。)
受保護的方法 AppendWithCommaText (繼承自 ScriptNameObjectBase。)
受保護的方法 AppendWithOption (繼承自 ScriptNameObjectBase。)
受保護的方法 BindDefaultImpl (繼承自 SqlSmoObject。)
受保護的方法 BindRuleImpl (繼承自 SqlSmoObject。)
受保護的方法 CheckCollation (繼承自 SqlSmoObject。)
公用方法 CheckIndex Tests the integrity of database pages that store the index.
公用方法 CheckIndexWithResult Tests the integrity of database pages that store the index.
受保護的方法 CheckObjectDirty (繼承自 ScriptNameObjectBase。)
受保護的方法 CheckObjectState() () () () Validates the state of the referenced object. (繼承自 SqlSmoObject。)
受保護的方法 CheckObjectState(Boolean) Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (繼承自 SqlSmoObject。)
受保護的方法 CheckObjectStateImpl (繼承自 SqlSmoObject。)
受保護的方法 CheckTextCorectness (繼承自 ScriptNameObjectBase。)
受保護的方法 CheckTextModeSupport (繼承自 ScriptNameObjectBase。)
受保護的方法 CheckVersion100 (繼承自 SqlSmoObject。)
受保護的方法 CheckVersion80 Checks the validity of the object on SQL Server 2000. (繼承自 SqlSmoObject。)
受保護的方法 CheckVersion80SP3 Checks the validity of the object on SQL Server 2000 SP3. (繼承自 SqlSmoObject。)
受保護的方法 CheckVersion90 Check the validity of the object on SQL Server 2005. (繼承自 SqlSmoObject。)
受保護的方法 CheckVersionBelow90 (繼承自 SqlSmoObject。)
受保護的方法 CleanObject Cleans the referenced object. (繼承自 ScriptNameObjectBase。)
公用方法 Create Creates an index on the instance of SQL Server as defined by the Index object.
受保護的方法 CreateImpl (繼承自 SqlSmoObject。)
受保護的方法 CreateImplFinish (繼承自 SqlSmoObject。)
受保護的方法 CreateImplInit (繼承自 SqlSmoObject。)
公用方法 Disable Disables the index.
公用方法 Discover (繼承自 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 with partition scheme parameters.
受保護的方法 DropImpl (繼承自 SqlSmoObject。)
受保護的方法 DropImplWorker (繼承自 SqlSmoObject。)
公用方法 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.
受保護的方法 EnumScriptImpl (繼承自 SqlSmoObject。)
受保護的方法 EnumScriptImplWorker (繼承自 SqlSmoObject。)
公用方法 EnumStatistics Enumerates a list of statistical information for the index.
公用方法 Equals (繼承自 Object。)
受保護的方法 Finalize (繼承自 Object。)
受保護的方法 ForceTextModeOnTextBody Enforces text mode on the text body. (繼承自 ScriptNameObjectBase。)
受保護的方法 FormatSqlVariant (繼承自 SqlSmoObject。)
受保護的方法 GenerateDataSpaceFileStreamScript (繼承自 SqlSmoObject。)
受保護的方法 GenerateDataSpaceScript (繼承自 SqlSmoObject。)
受保護的方法 GetBindDefaultScript (繼承自 SqlSmoObject。)
受保護的方法 GetBindRuleScript (繼承自 SqlSmoObject。)
受保護的方法 GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (繼承自 SqlSmoObject。)
受保護的方法 GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (繼承自 SqlSmoObject。)
受保護的方法 GetBraketNameForText (繼承自 ScriptNameObjectBase。)
受保護的方法 GetDateTimeParameter (繼承自 SqlSmoObject。)
受保護的方法 GetDateTimeParameterAsInt (繼承自 SqlSmoObject。)
受保護的方法 GetDBName Gets the database name that is associated with the object. (繼承自 SqlSmoObject。)
受保護的方法 GetEnumParameter (繼承自 SqlSmoObject。)
受保護的方法 GetFragOptionString (繼承自 SqlSmoObject。)
受保護的方法 GetGuidParameter (繼承自 SqlSmoObject。)
公用方法 GetHashCode (繼承自 Object。)
受保護的方法 GetIsTextDirty Determines whether the text value is consistent with stored value. (繼承自 ScriptNameObjectBase。)
受保護的方法 GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (繼承自 SqlSmoObject。)
受保護的方法 GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (繼承自 SqlSmoObject。)
受保護的方法 GetPropValue (繼承自 SqlSmoObject。)
受保護的方法 GetPropValueOptional (繼承自 SqlSmoObject。)
受保護的方法 GetPropValueOptionalAllowNull (繼承自 SqlSmoObject。)
受保護的方法 GetRealValue (繼承自 SqlSmoObject。)
受保護的方法 GetScriptIncludeExists (繼承自 ScriptNameObjectBase。)
受保護的方法 GetScriptingOptionsForCreate (繼承自 SqlSmoObject。)
受保護的方法 GetServerName Gets the name of the instance of SQL Server with which the object is associated. (繼承自 SqlSmoObject。)
受保護的方法 GetServerObject (繼承自 SqlSmoObject。)
受保護的方法 GetSqlServerVersionName Gets the version name of the instance of SQL Server with which the object is associated. (繼承自 SqlSmoObject。)
受保護的方法 GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (繼承自 SqlSmoObject。)
受保護的方法 GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (繼承自 SqlSmoObject。)
受保護的方法 GetTextBody() () () () Returns the text body. (繼承自 ScriptNameObjectBase。)
受保護的方法 GetTextBody(Boolean) Returns the text body. (繼承自 ScriptNameObjectBase。)
受保護的方法 GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] []) Gets the text for scripting. (繼承自 ScriptNameObjectBase。)
受保護的方法 GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [], Boolean) (繼承自 ScriptNameObjectBase。)
受保護的方法 GetTextHeader Returns the text header. (繼承自 ScriptNameObjectBase。)
受保護的方法 GetTextMode Determines whether the script name is using text mode. (繼承自 ScriptNameObjectBase。)
受保護的方法 GetTextProperty(String) (繼承自 ScriptNameObjectBase。)
受保護的方法 GetTextProperty(String, ScriptingOptions) (繼承自 ScriptNameObjectBase。)
受保護的方法 GetTimeSpanParameterAsInt (繼承自 SqlSmoObject。)
公用方法 GetType (繼承自 Object。)
受保護的方法 GetUrnRecursive(StringBuilder) (繼承自 SqlSmoObject。)
受保護的方法 GetUrnRecursive(StringBuilder, UrnIdOption) (繼承自 SqlSmoObject。)
受保護的方法 ImplInitialize (繼承自 SqlSmoObject。)
公用方法 Initialize() () () () Initializes the object and forces the properties be loaded. (繼承自 SqlSmoObject。)
公用方法 Initialize(Boolean) Initializes the object and forces the properties be loaded. (繼承自 SqlSmoObject。)
受保護的方法 IsObjectDirty Determines whether the referenced object is consistent with the stored object. (繼承自 ScriptNameObjectBase。)
受保護的方法 IsObjectInitialized Verifies whether the object has been initialized. (繼承自 SqlSmoObject。)
受保護的方法 IsObjectInSpace Verifies whether the object is isolated or connected to the instance of SQL Server. (繼承自 SqlSmoObject。)
受保護的方法 IsVersion80SP3 (繼承自 SqlSmoObject。)
受保護的方法 MarkDropped (繼承自 SqlSmoObject。)
公用方法 MarkForDrop Marks the index to be dropped the next time that the Alter method is run on the Index object's parent object.
受保護的方法 MarkForDropImpl (繼承自 SqlSmoObject。)
受保護的方法 MemberwiseClone (繼承自 Object。)
受保護的方法 PostAlter (繼承自 SqlSmoObject。)
受保護的方法 PostCreate (繼承自 SqlSmoObject。)
受保護的方法 PostDrop (繼承自 SqlSmoObject。)
公用方法 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. (覆寫 ScriptNameObjectBase. . :: . .Refresh() () () ()。)
公用方法 Rename Renames the index.
受保護的方法 RenameImpl This method supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 NamedSmoObject。)
受保護的方法 RenameImplWorker This method supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 NamedSmoObject。)
公用方法 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.
受保護的方法 ScriptAlter (繼承自 SqlSmoObject。)
受保護的方法 ScriptAnsiQI (繼承自 ScriptNameObjectBase。)
受保護的方法 ScriptChangeOwner This method supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 NamedSmoObject。)
受保護的方法 ScriptCreate (繼承自 SqlSmoObject。)
受保護的方法 ScriptDdl (繼承自 SqlSmoObject。)
受保護的方法 ScriptDrop (繼承自 SqlSmoObject。)
受保護的方法 ScriptImpl() () () () (繼承自 SqlSmoObject。)
受保護的方法 ScriptImpl(ScriptingOptions) (繼承自 SqlSmoObject。)
受保護的方法 ScriptImplWorker (繼承自 SqlSmoObject。)
受保護的方法 ScriptInformativeHeaders (繼承自 ScriptNameObjectBase。)
受保護的方法 ScriptRename This method supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 NamedSmoObject。)
受保護的方法 SetCollectionTextMode Sets the collection text mode. (繼承自 ScriptNameObjectBase。)
受保護的方法 SetParentImpl (繼承自 SqlSmoObject。)
受保護的方法 SetTextBody Specifies the text body. (繼承自 ScriptNameObjectBase。)
受保護的方法 SetTextHeader Specifies the text header. (繼承自 ScriptNameObjectBase。)
受保護的方法 SetTextMode Specifies the text mode. (繼承自 ScriptNameObjectBase。)
受保護的方法 SwitchTextMode Switches the text mode. (繼承自 ScriptNameObjectBase。)
受保護的方法 ThrowIfTextIsDirtyForAlter (繼承自 ScriptNameObjectBase。)
公用方法 ToString Returns a String that represents the referenced object. (繼承自 SqlSmoObject。)
受保護的方法 TouchImpl (繼承自 SqlSmoObject。)
受保護的方法 UnbindDefaultImpl (繼承自 SqlSmoObject。)
受保護的方法 UnbindRuleImpl (繼承自 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 (繼承自 SmoObjectBase。)

頂端

欄位

  名稱 描述
受保護的欄位 m_ExtendedProperties (繼承自 SqlSmoObject。)

頂端

屬性

  名稱 描述
公用屬性 BoundingBoxXMax Specifies the x-coordinate of the upper right corner of a bounding box
公用屬性 BoundingBoxXMin Specifies the x-coordinate of the lower-left corner of a bounding box.
公用屬性 BoundingBoxYMax Specifies the y-coordinate of upper-right corner of a bounding box.
公用屬性 BoundingBoxYMin Specifies the y-coordinate of the lower-left corner of a bounding box.
公用屬性 CellsPerObject Defines the maximum number of cells that tessellation can count per object.
公用屬性 CompactLargeObjects Gets or sets the Boolean property value that specifies whether to compact the large object (LOB) data in the index.
公用屬性 DisallowPageLocks Gets or sets the Boolean property value that specifies whether the index allows page locks.
公用屬性 DisallowRowLocks Gets or sets the Boolean property value that specifies whether the index allows row locks.
公用屬性 Events Gets the index events supported by the Index object.
受保護的屬性 ExecuteForScalar Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (繼承自 SqlSmoObject。)
公用屬性 ExtendedProperties Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the Index object.
公用屬性 FileGroup Gets or sets the filegroup where the index pages are stored.
公用屬性 FileStreamFileGroup Gets or Sets the file group name for the index.
公用屬性 FileStreamPartitionScheme Gets or Sets the partition scheme name for the index.
公用屬性 FillFactor Gets or sets the percentage of an index page to fill when the index is created or re-created.
公用屬性 FilterDefinition Gets or sets the String value that contains the definition for the filter.
公用屬性 HasCompressedPartitions Gets or sets the Boolean property value that specifies whether the index has compressed partitions.
公用屬性 HasFilter Gets the Boolean property value that specifies whether the index has a filter defined for a range of index values.
公用屬性 ID Gets the index ID value that uniquely identifies the index within the database.
公用屬性 IgnoreDuplicateKeys Gets or sets the Boolean property value that specifies whether the index ignores duplicate keys.
公用屬性 IndexedColumns Gets a collection of IndexedColumn objects that represent all the columns participating in the index.
公用屬性 IndexKeyType Gets or sets the index key type.
公用屬性 IsClustered Gets or sets the Boolean property value that specifies whether the index is clustered.
公用屬性 IsDisabled Gets or sets the Boolean property value that specifies whether the index is disabled.
公用屬性 IsFullTextKey Gets the Boolean value that specifies whether the index is enabled for row identification in Microsoft Search.
公用屬性 IsIndexOnComputed Gets the Boolean property value that specifies whether the index is based on a computed column.
公用屬性 IsIndexOnTable Gets the Boolean property value that specifies whether the index is defined for a table or a view.
公用屬性 IsPartitioned Gets the Boolean property value that specifies whether the index is stored in a partitioned scheme.
公用屬性 IsSpatialIndex Specifies if an index is a Spatial Index
公用屬性 IsSystemNamed Gets the Boolean property value that specifies whether the index was named automatically by the system.
公用屬性 IsSystemObject Gets the Boolean property value that specifies whether the index is a system object.
受保護的屬性 IsTouched Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (繼承自 SqlSmoObject。)
公用屬性 IsUnique Gets or sets the Boolean property value that specifies whether the index is unique or not.
公用屬性 IsXmlIndex Gets or sets the Boolean property value that specifies whether the index is an XML index.
公用屬性 Level1Grid Specifies the first level of decomposition for a geometry data type.
公用屬性 Level2Grid Specifies the second level of decomposition for a geometry data type.
公用屬性 Level3Grid Specifies the third level of decomposition for a geometry data type.
公用屬性 Level4Grid Specifies the fourth level of decomposition for a geometry data type.
公用屬性 MaximumDegreeOfParallelism Gets or sets the maximum number of processors that can be used when running a query that uses the index.
公用屬性 Name Gets or sets the name of the object. (繼承自 NamedSmoObject。)
公用屬性 NoAutomaticRecomputation Gets or sets the Boolean property value that specifies whether statistics are regenerated when an index is created.
受保護的屬性 ObjectInSpace Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (繼承自 SqlSmoObject。)
公用屬性 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.
公用屬性 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.
公用屬性 Parent Gets or sets the SqlSmoObject object that is the parent of the Index object.
公用屬性 ParentXmlIndex Gets or sets the parent of an XML index.
公用屬性 PartitionScheme Gets or sets the partition scheme associated with the index.
公用屬性 PartitionSchemeParameters Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a parameter in the partition scheme associated with the index.
公用屬性 PhysicalPartitions Gets a collection of PhysicalPartition objects that represent all the physical partitions on which the index is stored.
公用屬性 Properties Gets a collection of Property objects that represent the object properties. (繼承自 SqlSmoObject。)
受保護的屬性 ScalarResult Gets the scalar result for the referenced object. (繼承自 SqlSmoObject。)
公用屬性 SecondaryXmlIndexType Gets or sets the secondary XML index type.
公用屬性 SortInTempdb Gets or sets the Boolean property value that specifies whether the index is sorted using the tempdb database for intermediate storage of data.
公用屬性 SpaceUsed Gets or sets the disk space used to store the index data in kilobytes.
公用屬性 SpatialIndexType Gets or sets the Spatial Index Type for a column.
公用屬性 State Gets the state of the referenced object. (繼承自 SmoObjectBase。)
公用屬性 Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (繼承自 SqlSmoObject。)
公用屬性 UserData Gets or sets user-defined data associated with the referenced object. (繼承自 SmoObjectBase。)

頂端

事件

  名稱 描述
公用事件 PropertyChanged (繼承自 SqlSmoObject。)
公用事件 PropertyMetadataChanged (繼承自 SqlSmoObject。)

頂端

明確繼承實作  

  名稱 描述
明確介面實作私用方法 IAlienObjectDiscover (繼承自 SqlSmoObject。)
明確介面實作私用方法 IAlienObjectGetParent (繼承自 SqlSmoObject。)
明確介面實作私用方法 IAlienObjectGetProperty (繼承自 SqlSmoObject。)
明確介面實作私用方法 ISfcPropertyProviderGetPropertySet (繼承自 SqlSmoObject。)
明確介面實作私用方法 IAlienObjectGetUrn (繼承自 SqlSmoObject。)
明確介面實作私用方法 IAlienObjectResolve (繼承自 SqlSmoObject。)
明確介面實作私用方法 IAlienObjectSetProperty (繼承自 SqlSmoObject。)

頂端