This topic has not yet been rated - Rate this topic

DefaultRuleBase.ScriptCreate Method

SQL Server 2008

Creates a new rule script.

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

Syntax

C++

JScript

protected override void ScriptCreate(
	StringCollection queries,
	ScriptingOptions so
)

Parameters

queries: 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.

Reference

DefaultRuleBase Class

DefaultRuleBase Members

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD