When I type queries in the editor, in particular joins, the editor shows in the code completion options for joining with different tables. This is very good. But when I select a join, Toad adds the full table name and it also prefixes the column names with the full table name.
I usually like to use aliases for tables and I was thinking that it would be nice if there was a way to assign an alias to a table in Toad, so next time when Toad adds a join it uses that alias instead of the full table name.
If Toad doesn’t support this yet, can I request this feature? What do you think?
I just wanted to emphasize one more thing, it would be nice if Toad allows the user to specify tables aliases manually, in case he/she doesn’t like the automatic alias generated by Toad. You now, right-click in the object Explorer on a table, and provide an option, ‘Table Alias’, and when selected display a simple dialog to assign the desired table alias.
Toad for SQL Server 6.6 will be release very soon. Maybe in Apr or May.
The requirement you mentioned, we already have a function to allow user specify object aliases manually (Object Explorer|Database|Synonyms). I think we can add
an option to allow user use these specify aliases if they don’t like the auto aliases, how do you think?