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.
27
votes
Jens Meyer
shared this idea
-
Tsahi
commented
Or mark them in some way, such as grayed out.