SA0071A : Check all Foreign Key Constraints in the current database for following specified naming convention |  |
The topic describes the SA0071A analysis rule.
MessageCheck all Foreign Key Constraints in the current database for following specified naming convention
DescriptionThe rule checks the naming of all foreign key 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:
{parent_table_name} - Name of the parent table.
{referenced_table_name} - Name of the referenced table.
{parent_columns_list} - List of parent table columns.
{referenced_columns_list} - List of referenced table columns.
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 |
|---|---|---|
| NamePattern | Foreign key constraint name pattern. | regexp:FK_[A-Z][A-Za-z_]+ |
| ColumnsListSeparator | Separator which to be used for separating the columns in the {parent_column_list} and {referenced_column_list} placeholders. | _ |
| PairedColumnsSeparator | Separator which to be used for separating parent and referenced columns. |
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