Enhancement Request

[Chad Autry]

I query our database using the sql window alot, and I find myself writing many sql statements with the same tables, and I of course tend to use the same aliases for them. For example CUSTOMER_ACCOUNT_PRIVILEGE is always cap and ACCOUNT is always a.

I would find it handy if I could define local aliases from my commonly used tables that would autocomplete into the full table name in the select statement.

What I'm imagining is I'd type "select a.* from a, cap where a.account_no = cap.account_no" and it would fill it would fill in my pre-defined table names for me to get "select a.* from account a, customer_account_privilege cap where a.account_no = cap.account_no"

If it automatically filled in the mapping with commonly used aliases (with the option to lock an alias to a table) that would be awesome.

 

[Marco Kalter]

There is an AutoReplace (Tools > Preferences > User Interface / Editor) option, though this may not be exactly what you need. It allows you to define general abbreviations and replacement texts. It does not allow you to replace only the aliases after a from clause though.

I have added this to the list of enhancement requests.

 

[Chad Autry]

Thanks for pointing out AutoReplace. I've been able to accomplish the majority of what I wanted by mapping a modification of my alis to the full table name and alias.

rcap = customer_account_privilege cap
ra = account a