I would be nice to have an option i behavior to automatically finding unused variables and parameters. (like suggestions / definitions)80 votes
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.24 votes
I was a bit surprised that SQL Prompt does not Identify and highlight duplicated variable names. Seems like an important omission.
Please extend the 'Find Unused Variables' to include identifying any duplicated variable names.1 vote
- Don't see your idea?