32 lines (22 loc) · 718 Bytes

SQL Server Rule: SRD0006


Assembly	SqlServer.Rules.dll
Namespace	SqlServer.Rules.Design
Class	AvoidSelectStarRule

Rule Information


Id	SRD0006
Friendly Name	Avoid SELECT *
Category	Design
Ignorable	true
Applicable Types	Procedure
	Scalar Function
	Table Valued Function
	View

Description

Avoid using SELECT *.

Summary

Avoid the use of SELECT *. This can cause more columns than desired to be returned, and can also cause issues if the order of the columns changes.