VOV: Get database column names using vovsql_query

When you run a query against the vovdatabase in NetworkComputer or LicenseMonitor, the results will not contain column names, which are useful for spreadsheets.

To get the column names in a separate query, enter the following, for example:

% source /path-to-rtda/common/etc/vovrc.{csh,sh}  # use the one for your shell type
% vovproject enable licmon
% vovsql_query -rw -e "select column_name from information_schema.columns where table_name='checkouts'"

Did you find this article helpful?