Metodo ScriptAlter
Alters an existing rule script.
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
Protected Overrides Sub ScriptAlter ( _
alterQuery As StringCollection, _
so As ScriptingOptions _
)
'Utilizzo
Dim alterQuery As StringCollection
Dim so As ScriptingOptions
Me.ScriptAlter(alterQuery, so)
protected override void ScriptAlter(
StringCollection alterQuery,
ScriptingOptions so
)
protected:
virtual void ScriptAlter(
StringCollection^ alterQuery,
ScriptingOptions^ so
) override
abstract ScriptAlter :
alterQuery:StringCollection *
so:ScriptingOptions -> unit
override ScriptAlter :
alterQuery:StringCollection *
so:ScriptingOptions -> unit
protected override function ScriptAlter(
alterQuery : StringCollection,
so : ScriptingOptions
)
Parametri
- alterQuery
Tipo: System.Collections.Specialized. . :: . .StringCollection
StringCollection object containing the revised query.
- so
Tipo: Microsoft.SqlServer.Management.Smo. . :: . .ScriptingOptions
ScriptingOptionsobject contains options associated with the script.
Osservazioni
In SMO, rules are represented by the Rule object. The rule is defined by the TextBody property, which is a text string that contains a condition expression that uses operators or predicates, such as IN, LIKE, or BETWEEN. A rule cannot reference columns or other database objects. Built-in functions that do not reference database objects can be included.