I suggest you...

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

my_stupid_client_table

i could set an alias of stupidClient to it

so when I typed

select from my_stupid_client_table

autocomplete would use the alias for the table i previously specified to give

select from my_stupid_client_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.

4 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Willem shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Timbald commented  ·   ·  Flag as inappropriate

        Oh yes this really annoys me that the aliases always come up t, t2. Please add this facility.

      Feedback and Knowledge Base