Give us a configurable option to "Always show table schema in suggestions list"
We use a separate schema (z_audit) to capture data changes from dbo tables as a complete audit trail. The tables in each schema are named the same. Every time I come to the suggestions list, I either take it as read that the top table listed is in the dbo schema, or must click that little arrow at bottom-left to "show schema", involving having to grab the mouse just to expose the schema when we're supposed to be efficiently keying; no mousing involved unless we need to use a different suggestions tab...
An option that toggles this to OUR preference would be appreciated, and should be very easy to incorporate.
Perhaps, once we choose to expose the schema, the suggestion pop-up can "remember" that so it shows the schema every time a table-picker list is presented...? (This should be even easier to implement given the fact that the pop-up dimensions are already "remembered".)
Thanks.
Stephen Anslow
shared this idea
This is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/