Suggest only column names after a Table alias is typed in
If I have already typed in the alias name for a table, then suggestions after a period should always have the column names at the top. Sometimes, a code snippet shortcut or other unrelated item pops to the top of the list.
For example, if I am have typed in:
SELECT * FROM [sys].[tables] AS T
WHERE [T].is
Then, the snippet for INFORMATIONSCHEMA shows at the top of the list. Since I already have put [T]., it should have the column names such as ismerged_published, etc. at the top of the list.
![](https://secure.gravatar.com/avatar/c7fb1d74784a1d215f69600618f39ac2?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Stephen commented
Definitely a pain, especially if one has a convention of using names like Is<Condition> for bit columns... IsValidated, IsGood, IsActive for example. Lost count of how many times INFORMATION_SCHEMA has landed up in my code...