Add ability to search for identifiers (tables, columns, indexes, etc.)
There is currently no way to search for an identifier, e.g., a column name, without also matching text that contains that identifier. For example, if I want to search for a column called ExampleColumn but ignore ExampleColumn2, BadExampleColumn, etc., I could try the "Match whole words only" option. I want it to find all of these:
SELECT ExampleColumn FROM ExampleTable;
SELECT ExampleColumn, OtherColumn FROM ExampleTable;
SELECT [ExampleColumn] FROM ExampleTable;
SELECT et.ExampleColumn FROM ExampleTable et;
SELECT * FROM ExampleTable WHERE ExampleColumn=3;
SELECT SUM(ExampleColumn) FROM ExampleTable;
but only the first three are found. Without the whole words option, it would match all of the above, but would also match these:
SELECT NewExampleColumn FROM ExampleTable;
SELECT BadExampleColumn FROM ExampleTable;
SELECT ExampleColumn2 FROM ExampleTable;
Adding the ability to effectively search for identifiers, either as a new feature or by changing the definition of "whole word" to align with SQL identifiers, would make SQL Search much more useful, I think.
![](https://secure.gravatar.com/avatar/2946e8473062969d57d59779fa6cb410?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)