Click or drag to resize

SA0048 : Table does not have a primary key or unique key

The topic describes the SA0048 analysis rule.

Message

Table does not have a primary key or unique key

Description

The rule checks all tables in the current database for having a primary key or a unique key defined.

Scope

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

Parameters
NameDescriptionDefault Value
RequiredKeyType

Parameter specifies the type of key for which the rule will look.

PrimaryOrUnique

Remarks

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

Categories

Performance Rules

Additional Information

There is no additional info for this rule.

See Also

Other Resources