VOV: Get database column names using vovsql_query
AlanB_22262
New Altair Community Member
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'"
0