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.

How to fix

Create a primary key for the reported table.

Scope

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

Parameters
Name Description Default 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.

Effort To Fix
20 minutes per issue.
Categories

Performance Rules, Bugs

Additional Information

There is no additional info for this rule.

See Also

Other Resources