Start a new topic

Displaying column names rather than title names in a Result Set?

[This topic is migrated from our old forums. The original author name has been removed]

Hi - Is there a setting in DBVisualizer that will show the actual column names in the results set as opposed to the TITLE name. For example, my query returns 'Employee ID' and 'Customer ID' rather than EMPLY_ID and CSTMR_ID. Here is how those 2 attributes are defined: EMPLY_ID DECIMAL(18,0) TITLE 'Employee ID' NOT NULL, CSTMR_ID DECIMAL(18,0) TITLE 'Customer ID' NOT NULL Thank you in advance..

[This reply is migrated from our old forums. The original author name has been removed]

Re: Displaying column names rather than title names in a Result Set?
Roger, Thank you very much. That worked! Best, Conor
[This reply is migrated from our old forums.]

Re: Displaying column names rather than title names in a Result Set?
Hi, Open Tools->Tool Properties and select the General / Grid category to the left. Now to the right scroll down a bit and you will find "Show Column Alias as Column Label". Uncheck it press OK and then try again. Regards Roger