DefaultRuleBase.ScriptAlter Method
Alters an existing rule script.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Protected Overrides Sub ScriptAlter ( _
alterQuery As StringCollection, _
so As ScriptingOptions _
)
'Usage
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
)
Parameters
- alterQuery
Type: System.Collections.Specialized.StringCollection
StringCollection object containing the revised query.
- so
Type: Microsoft.SqlServer.Management.Smo.ScriptingOptions
ScriptingOptionsobject contains options associated with the script.
Remarks
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.