I would be nice to have an option i behavior to automatically finding unused variables and parameters. (like suggestions / definitions)99 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.23 votes
Would be nice if this option (or a new one) highlighted JOINs that are not used elsewhere in the query. As applications evolve or new ones added, desired information may shift to a new table, and the old column retained for legacy purposes. When we revise a procedure to use the new information instead, the old JOIN may become unnecessary, and "housekeeping" to clean these up can cause problems in large queries if not done carefully. Would be acceptable if use of this feature required the use of table aliases, if that would make it easier to implement.4 votes
Create similar panel like Find Results for Find Unused Variables and Parameters in Microsoft SQL Server Management Studio.1 vote
Thanks for providing a feature to find all the unused variables but can you please provide a feature to comment/remove unused variables?
Step 1: At first I want to comment out all the unused variables.
Note: In these comments there must be a keyword (e.g. UVC To make it different from other comments) which can be helpful to remove it later after proper testing.
Step 2: After some testing(may be in if I find everything works fine I want to remove all the unused variables permanently to make a final copy.1 vote
- Don't see your idea?