T-SQL Analyzer

# SQL Server Rule: SRD0006 | | | |----|----| | Assembly | SqlServer.Rules | | 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. ### Examples ```sql Create view [dbo].[err] AS SELECT * FROM [TestTableSSDT] -- SRD0006, SRD0039 ``` _{^{Generated by a tool}}