Rule 類別
The Rule object provides programmatic access to a SQL Server rule.
命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)> _
Public NotInheritable Class Rule _
Inherits DefaultRuleBase
'用途
Dim instance As Rule
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)]
public sealed class Rule : DefaultRuleBase
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute(PhysicalFacetOptions::ReadOnly)]
public ref class Rule sealed : public DefaultRuleBase
[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)>]
type Rule =
class
inherit DefaultRuleBase
end
public final class Rule extends DefaultRuleBase
備註
To get Rule object properties, users can be a member of the public fixed server role.
To set Rule object properties, users must have CREATE RULE permission on the parent database or be a member of the db_owner fixed database role.
To create a rule, users must have CREATE RULE permission on the parent database or be a member of the db_owner fixed database role.
To drop a rule, users must have ALTER permission on the schema to which the rule belongs.
To bind or unbind a rule to a table, users must have ALTER permission on the table.
To bind or unbind a rule to a data type, users must have ALTER permission on the schema to which the data type belongs.
Thread Safety
這種類型的任何公用靜態 (在 Microsoft Visual Basic 中則為 Shared) 成員都可用於多執行緒作業。並不是所有的執行個體成員都保證可以用於所有的執行緒。
繼承階層
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
Microsoft.SqlServer.Management.Smo. . :: . .SqlSmoObject
Microsoft.SqlServer.Management.Smo. . :: . .NamedSmoObject
Microsoft.SqlServer.Management.Smo. . :: . .ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo. . :: . .ScriptSchemaObjectBase
Microsoft.SqlServer.Management.Smo. . :: . .DefaultRuleBase
Microsoft.SqlServer.Management.Smo..::..Rule
執行緒安全性
這個類型的任何公用static (在 Visual Basic 中為 Shared) 成員都是安全執行緒。不保證任何執行個體成員都可以是安全執行緒。