set aliases for tables once and use in all sql scripts from then on
I would love to be able to right click on a table and set an alias for that table that would then be used in the alias for scripts from then on rather than having to edit them each time
for eg
mystupidclient_table
i could set an alias of stupidClient to it
so when I typed
select from mystupidclient_table
autocomplete would use the alias for the table i previously specified to give
select from mystupidclient_table stupidClient
ideally we could autocomplete on the specified aliases with a seperate hotkey, tab vs ctrl->space perhaps where one autocompleted as it does now and the other autcompleted on out specified aliases so i could type
select * from stupid
and the correct autocomplete key to complete the way it does now or on my specified aliases only.
-
Timbald commented
Oh yes this really annoys me that the aliases always come up t, t2. Please add this facility.