Membres Statistic
The Statistic class represents a SQL Server statistic counter.
Le type Statistic expose les membres suivants.
Constructeurs
Nom | Description | |
---|---|---|
Statistic() () () () | Initializes a new instance of the Statistic class. | |
Statistic(SqlSmoObject, String) | Initializes a new instance of the Statistic class on the specified parent object and with the specified name. |
Haut de la page
Méthodes
Nom | Description | |
---|---|---|
AddDatabaseContext | (Hérité de SqlSmoObject.) | |
AlterImpl | (Hérité de SqlSmoObject.) | |
AlterImplFinish | (Hérité de SqlSmoObject.) | |
AlterImplInit | (Hérité de SqlSmoObject.) | |
AlterImplWorker | (Hérité de SqlSmoObject.) | |
AppendCommaText | (Hérité de ScriptNameObjectBase.) | |
AppendWithCommaText | (Hérité de ScriptNameObjectBase.) | |
AppendWithOption | (Hérité de ScriptNameObjectBase.) | |
BindDefaultImpl | (Hérité de SqlSmoObject.) | |
BindRuleImpl | (Hérité de SqlSmoObject.) | |
CheckCollation | (Hérité de SqlSmoObject.) | |
CheckObjectDirty | (Hérité de ScriptNameObjectBase.) | |
CheckObjectState() () () () | Validates the state of the referenced object. (Hérité de 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. (Hérité de SqlSmoObject.) | |
CheckObjectStateImpl | (Hérité de SqlSmoObject.) | |
CheckTextCorectness | (Hérité de ScriptNameObjectBase.) | |
CheckTextModeSupport | (Hérité de ScriptNameObjectBase.) | |
CheckVersion100 | (Hérité de SqlSmoObject.) | |
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Hérité de SqlSmoObject.) | |
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Hérité de SqlSmoObject.) | |
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Hérité de SqlSmoObject.) | |
CheckVersionBelow90 | (Hérité de SqlSmoObject.) | |
CleanObject | Cleans the referenced object. (Hérité de ScriptNameObjectBase.) | |
Create | Creates a statistics counter on the instance of SQL Server as defined by the Statistic object. | |
CreateImpl | (Hérité de SqlSmoObject.) | |
CreateImplFinish | (Hérité de SqlSmoObject.) | |
CreateImplInit | (Hérité de SqlSmoObject.) | |
Discover | (Hérité de SqlSmoObject.) | |
Drop | Removes the statistic counter. | |
DropImpl | (Hérité de SqlSmoObject.) | |
DropImplWorker | (Hérité de SqlSmoObject.) | |
EnumScriptImpl | (Hérité de SqlSmoObject.) | |
EnumScriptImplWorker | (Hérité de SqlSmoObject.) | |
Equals | (Hérité de Object.) | |
Finalize | (Hérité de Object.) | |
ForceTextModeOnTextBody | Enforces text mode on the text body. (Hérité de ScriptNameObjectBase.) | |
FormatSqlVariant | (Hérité de SqlSmoObject.) | |
GenerateDataSpaceFileStreamScript | (Hérité de SqlSmoObject.) | |
GenerateDataSpaceScript | (Hérité de SqlSmoObject.) | |
GetBindDefaultScript | (Hérité de SqlSmoObject.) | |
GetBindRuleScript | (Hérité de SqlSmoObject.) | |
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Hérité de SqlSmoObject.) | |
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Hérité de SqlSmoObject.) | |
GetBraketNameForText | (Hérité de ScriptNameObjectBase.) | |
GetDateTimeParameter | (Hérité de SqlSmoObject.) | |
GetDateTimeParameterAsInt | (Hérité de SqlSmoObject.) | |
GetDBName | Gets the database name that is associated with the object. (Hérité de SqlSmoObject.) | |
GetEnumParameter | (Hérité de SqlSmoObject.) | |
GetFragOptionString | (Hérité de SqlSmoObject.) | |
GetGuidParameter | (Hérité de SqlSmoObject.) | |
GetHashCode | (Hérité de Object.) | |
GetIsTextDirty | Determines whether the text value is consistent with stored value. (Hérité de ScriptNameObjectBase.) | |
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Hérité de SqlSmoObject.) | |
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Hérité de SqlSmoObject.) | |
GetPropValue | (Hérité de SqlSmoObject.) | |
GetPropValueOptional | (Hérité de SqlSmoObject.) | |
GetPropValueOptionalAllowNull | (Hérité de SqlSmoObject.) | |
GetRealValue | (Hérité de SqlSmoObject.) | |
GetScriptIncludeExists | (Hérité de ScriptNameObjectBase.) | |
GetScriptingOptionsForCreate | (Hérité de SqlSmoObject.) | |
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Hérité de SqlSmoObject.) | |
GetServerObject | (Hérité de SqlSmoObject.) | |
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Hérité de SqlSmoObject.) | |
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Hérité de SqlSmoObject.) | |
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Hérité de SqlSmoObject.) | |
GetTextBody() () () () | Returns the text body. (Hérité de ScriptNameObjectBase.) | |
GetTextBody(Boolean) | Returns the text body. (Hérité de ScriptNameObjectBase.) | |
GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] []) | Gets the text for scripting. (Hérité de ScriptNameObjectBase.) | |
GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [], Boolean) | (Hérité de ScriptNameObjectBase.) | |
GetTextHeader | Returns the text header. (Hérité de ScriptNameObjectBase.) | |
GetTextMode | Determines whether the script name is using text mode. (Hérité de ScriptNameObjectBase.) | |
GetTextProperty(String) | (Hérité de ScriptNameObjectBase.) | |
GetTextProperty(String, ScriptingOptions) | (Hérité de ScriptNameObjectBase.) | |
GetTimeSpanParameterAsInt | (Hérité de SqlSmoObject.) | |
GetType | (Hérité de Object.) | |
GetUrnRecursive(StringBuilder) | (Hérité de SqlSmoObject.) | |
GetUrnRecursive(StringBuilder, UrnIdOption) | (Hérité de SqlSmoObject.) | |
ImplInitialize | (Hérité de SqlSmoObject.) | |
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.) | |
IsObjectDirty | Determines whether the referenced object is consistent with the stored object. (Hérité de ScriptNameObjectBase.) | |
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.) | |
IsVersion80SP3 | (Hérité de SqlSmoObject.) | |
MarkDropped | (Hérité de SqlSmoObject.) | |
MarkForDrop | Marks the statistics counter to be dropped next time its parent SqlSmoObject object is altered with the ALTER method. | |
MarkForDropImpl | (Hérité de SqlSmoObject.) | |
MemberwiseClone | (Hérité de Object.) | |
PostAlter | (Hérité de SqlSmoObject.) | |
PostCreate | (Hérité de SqlSmoObject.) | |
PostDrop | (Hérité de SqlSmoObject.) | |
Refresh | Refreshes the script name. (Hérité de ScriptNameObjectBase.) | |
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) | |
RenameImplWorker | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) | |
Script() () () () | Generates a Transact-SQL script that can be used to re-create the database. | |
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the database as specified by the script options. | |
ScriptAlter | (Hérité de SqlSmoObject.) | |
ScriptAnsiQI | (Hérité de ScriptNameObjectBase.) | |
ScriptChangeOwner | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) | |
ScriptCreate | (Hérité de SqlSmoObject.) | |
ScriptDdl | (Hérité de SqlSmoObject.) | |
ScriptDrop | (Hérité de SqlSmoObject.) | |
ScriptImpl() () () () | (Hérité de SqlSmoObject.) | |
ScriptImpl(ScriptingOptions) | (Hérité de SqlSmoObject.) | |
ScriptImplWorker | (Hérité de SqlSmoObject.) | |
ScriptInformativeHeaders | (Hérité de ScriptNameObjectBase.) | |
ScriptRename | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) | |
SetCollectionTextMode | Sets the collection text mode. (Hérité de ScriptNameObjectBase.) | |
SetParentImpl | (Hérité de SqlSmoObject.) | |
SetScanOptions | Sets the scan options for the statistic counter. | |
SetTextBody | Specifies the text body. (Hérité de ScriptNameObjectBase.) | |
SetTextHeader | Specifies the text header. (Hérité de ScriptNameObjectBase.) | |
SetTextMode | Specifies the text mode. (Hérité de ScriptNameObjectBase.) | |
SwitchTextMode | Switches the text mode. (Hérité de ScriptNameObjectBase.) | |
ThrowIfTextIsDirtyForAlter | (Hérité de ScriptNameObjectBase.) | |
ToString | Returns a String that represents the referenced object. (Hérité de SqlSmoObject.) | |
TouchImpl | (Hérité de SqlSmoObject.) | |
UnbindDefaultImpl | (Hérité de SqlSmoObject.) | |
UnbindRuleImpl | (Hérité de SqlSmoObject.) | |
Update() () () () | Updates the statistics for the referenced object. | |
Update(StatisticsScanType) | Updates information about the distribution of key values. | |
Update(StatisticsScanType, Int32) | Updates information about the distribution of key values. | |
Update(StatisticsScanType, Int32, Boolean) | Updates information about the distribution of key values. | |
Validate | (Hérité de SmoObjectBase.) |
Haut de la page
Propriétés
Nom | Description | |
---|---|---|
Events | Gets the events associated with the database. | |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Hérité de SqlSmoObject.) | |
FileGroup | Gets or sets the file group where the statistic counter is stored. | |
FilterDefinition | ||
HasFilter | ||
ID | Gets the ID value that uniquely identifies the statistic counter. | |
IsAutoCreated | Gets the Boolean property value that specifies whether the statistic counter is automatically created. | |
IsFromIndexCreation | Gets the Boolean property value that specifies whether the statistic counter was generated from the creation of an index. | |
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Hérité de SqlSmoObject.) | |
LastUpdated | Gets the date and time when the statistic counter was last updated. | |
Name | Gets or sets the name of the object. (Hérité de NamedSmoObject.) | |
NoAutomaticRecomputation | Gets or sets the Boolean property value that specifies whether the statistics counter recomputed automatically. | |
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. (Hérité de SqlSmoObject.) | |
Parent | Gets or sets the SqlSmoObject object that is the parent of the Statistic object. | |
Properties | Gets a collection of Property objects that represent the object properties. (Hérité de SqlSmoObject.) | |
ScalarResult | Gets the scalar result for the referenced object. (Hérité de SqlSmoObject.) | |
State | Gets the state of the referenced object. (Hérité de SmoObjectBase.) | |
StatisticColumns | Represents a collection of StatisticColumn objects. Each StatisticColumn object represents a column defined on the statistic counter. | |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Hérité de SqlSmoObject.) | |
UserData | Gets or sets user-defined data associated with the referenced object. (Hérité de SmoObjectBase.) |
Haut de la page
Événements
Nom | Description | |
---|---|---|
PropertyChanged | (Hérité de SqlSmoObject.) | |
PropertyMetadataChanged | (Hérité de SqlSmoObject.) |
Haut de la page
Implémentations d'interfaces explicites
Nom | Description | |
---|---|---|
IAlienObjectDiscover | (Hérité de SqlSmoObject.) | |
IAlienObjectGetParent | (Hérité de SqlSmoObject.) | |
IAlienObjectGetProperty | (Hérité de SqlSmoObject.) | |
ISfcPropertyProviderGetPropertySet | (Hérité de SqlSmoObject.) | |
IAlienObjectGetUrn | (Hérité de SqlSmoObject.) | |
IAlienObjectResolve | (Hérité de SqlSmoObject.) | |
IAlienObjectSetProperty | (Hérité de SqlSmoObject.) |
Haut de la page