SA0065A : Check all Triggers for following specified naming convention |  |
The topic describes the SA0065A analysis rule.
MessageCheck all Triggers for following specified naming convention
DescriptionThe 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.
ScopeThe rule has a ContextOnly scope and is applied only on current server and database schema.
Parameters| Name | Description | Default 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) |
RemarksThe rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.
CategoriesNaming Rules
Additional InformationThere is no additional info for this rule.
See Also