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 Monitor

SQL Prompt

 SQL Code Guard