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?
Update: I posted this idea: http://www.toadworld.com/products/toad-for-sql-server/i/sql_editor/allow_users_to_define_table_aliases_manually_and_use_those_in_the_generated_code_wherever_it_applies.aspx