Click or drag to resize

SA0065A : Check all Triggers for following specified naming convention.(Context Only)

The topic describes the SA0065A analysis rule.

Message

Check all Triggers for following specified naming convention.(Context Only)

Description

The rule checks the naming of all triggers in the current database.

Separate name patterns are available for table triggers and database, or server triggers.

For table triggers, a schema qualified name pattern is also available.

The following placeholders will be replaced in the pattern during the key testing:

{table_name}

{trigger_events}

{schema_name}

Regular expression patterns can be used, but the pattern must be prefixed with 'regexp:' string in order to be used as a matching regular expression.

Scope

The rule has a ContextOnly scope and is applied only on current server and database schema.

Parameters
NameDescriptionDefault Value
DmlTriggerNamePattern

Table triggers name pattern.

trig_{trigger_events}{table_name}

DmlTriggerSchemaQualifiedNamePattern

DmlTrigger schema qualified name pattern.

-

DdlTriggerNamePattern

Database and server triggers name pattern.

regexp:{trigger_events}[A-Z][A-Za-z1-9_]+

InsertEventName

Event name which to be used in the {trigger_events} placeholder for the specific event type.

i

UpdateEventName

Event name which to be used in the {trigger_events} placeholder for the specific event type.

u

DeleteEventName

Event name which to be used in the {trigger_events} placeholder for the specific event type.

d

TriggerEventsListSeparator

Separator for the event in the {trigger_events} placeholder.

DdlTriggerEventNames

Specifies how the trigger event types are set in the {trigger_events} placeholder.

Use first letter of each word (lowercase)

Remarks

The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.

Categories

Naming Rules

Additional Information

There is no additional info for this rule.

See Also

Other Resources