Custom aliases for multiple query result tabs?
Posted: Mon 20 Apr 2015 22:39
Hi Folks,
Maybe this is a silly question with a simple answer but I can't figure out a way to do it:
Is there a way to give a custom alias or nickname to the query result tab that appears when executing multiple queries within the same SQL script?
For example running 'F5' on the following queries:
SELECT * from addresses a;
SELECT * from buildings b;
Will return two query result tabs named like so:
TABS: [addresses];[buildings]
(It seems dbForge names each resulting tab based on the primary name of the first table within each of the select statements)
Is there a way I can tell it to use the table alias instead to get something like this?:
TABS: [a];
Thanks!
--Erik
Maybe this is a silly question with a simple answer but I can't figure out a way to do it:
Is there a way to give a custom alias or nickname to the query result tab that appears when executing multiple queries within the same SQL script?
For example running 'F5' on the following queries:
SELECT * from addresses a;
SELECT * from buildings b;
Will return two query result tabs named like so:
TABS: [addresses];[buildings]
(It seems dbForge names each resulting tab based on the primary name of the first table within each of the select statements)
Is there a way I can tell it to use the table alias instead to get something like this?:
TABS: [a];
Thanks!
--Erik
