Click or drag to resize

SA0085 : Check database objects for missing specific extended properties

The topic describes the SA0085 analysis rule.

Message

Check database objects for missing specific extended properties

Description

The rule checks and reports database objects that are missing one of specified extended properties.

The extended properties can be used for creating self-documenting databases or by third third-party tools for generating database documentation.

Note Note

The rule requires full analysis context.

To suppress checking of specific object type, set empty value to the object type's required properties parameter.

For example: If ViewRequiredProperties has empty value, the views will not be checked.

Scope

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

Parameters
NameDescriptionDefault Value
DatabaseRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

FunctionRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

StoredProcedureRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

ViewRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

TableRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

TriggerRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

DatabasePrincipalRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

SchemaRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

DataTypeRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

AssemblyRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

MessageTypeRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

RuleRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

DefaultRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

ServiceRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

ServiceBindingRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

ServiceContractRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

RouteRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

XmlSchemaCollectionRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

DataSpaceRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

FileGroupRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

PartitionFunctionRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

DatabaseFileRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

PrimaryKeyConstraintRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

CheckConstraintRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

ForeignKeyConstraintRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

SynonymRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

IndexRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

ColumnRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

ParameterRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

UniqueConstraintRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

DefaultConstraintRequiredProperties

Comma separated list of required extended properties for the object type.

MS_Description

Remarks

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

Categories

Design Rules

Additional Information

There is no additional info for this rule.

See Also

Other Resources