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.