customize the tab label on a multiple query sql window

Lloyd

Member
If I am running multiple queries in a SQL Window and then copying all to excel. It names the tabs

"Select table1"
"Select table2"
"Select table1"

Is there a handy way to notate my sql so that I can put a custom message in that tab?
 
You can use the TAB= directive. For example:

Code:
-- TAB=Departmnents
select * from dept;

-- TAB=Employees
select * from emp;

The description will appear in the tab names of the SQL Window as well as in the Excel export.
 
Back
Top