Click or drag to resize

SA0067A : Check all Unique Key Constraints in the current database for following specified naming convention

The topic describes the SA0067A analysis rule.

Message

Check all Unique Key Constraints in the current database for following specified naming convention

Description

The rule checks the naming of all unique constraints in the current database.

The NamePattern variable can be used to select or configure the desired pattern which will be used to check the object name.

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

{table_name} - Name of the key's parent table.

{column_list} - List of the key columns, ordered by key ordinal and separated by underscore('_').

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
NamePattern

Unique key name pattern.

UK_{table_name}_{column_list}

ColumnsListSeparator

Separator which to be used for separating the columns in the {column_list} placeholder.

_

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