PlanGuide Properties

PlanGuide Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyExtendedProperties

Gets a collection of plan guide properties.

System_CAPS_pubpropertyHints

Shows the hints that are associated with the plan guide.

System_CAPS_pubpropertyID

Gets the identifier of the plan guide.

System_CAPS_pubpropertyIsDisabled

Indicates whether a plan guide is disabled.

System_CAPS_pubpropertyName

Gets or sets the name of the object.(Inherited from NamedSmoObject.)

System_CAPS_pubpropertyParameters

Gets a string that lists all the plan guide parameters.

System_CAPS_pubpropertyParent

Gets the parent database object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyScopeBatch

Gets or sets the scope batch of the plan guide.

System_CAPS_pubpropertyScopeObjectName

Gets or sets the scope object name.

System_CAPS_pubpropertyScopeSchemaName

Gets or sets the scope schema name.

System_CAPS_pubpropertyScopeType

Gets or sets the plan guide scope type.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyStatement

Gets or sets a plan guide statement (query).

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show:
© 2016 Microsoft