Find unused columns in SELECT statements
Find unused columns in SELECT statements similar to finding unused variables.
Use case: I have some subqueries where I expanded SELECT * to now explicitly specify column names (best practice). However, only some of the columns and then used in the query process or results. I thus want the ability to have the unused columns removed from the SELECT statement.
28
votes

-
Tsahi commented
Or mark them in some way, such as grayed out.