Code Analysis

DEP026

Three-part and four-part column references in SELECT list are deprecated

Three-part and four-part column references in SELECT list are deprecated – two-part names is the standard-compliant behavior.

Sometimes, when a table is referenced in another database or server, programmers believe that the two or three-part table name needs to be applied to the columns. This is unnecessary and meaningless. Just the table name is required for the columns.

Available in

SQL Prompt

SQL Code Guard



Didn't find what you were looking for?