• Artigo

Classe Rule

The Rule object provides programmatic access to a SQL Server rule.

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

Sintaxe

'Declaração
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)> _
Public NotInheritable Class Rule _
    Inherits DefaultRuleBase
'Uso
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

Comentários

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

Qualquer membro público estático (Compartilhado no Microsoft Visual Basic) desse tipo é seguro para operações multi-threaded. Não há garantia de que qualquer membro de instância seja seguro para threads.

Segurança de thread

Quaisquer membros static (Shared no Visual Basic) públicos deste tipo são thread-safe. Não há garantia de que qualquer membro de instância seja thread-safe.