This appendix lists the external names of all columns (except where noted) returned for all queries listed by adapter. For some queries, certain columns cannot be known until the query runs.
Note the following guidelines:
-
To confirm the column names for all queries, including the any view queries not included here, check the mtb_server.log file after you run a query. For the OLE DB, do not include the column parameter until you have checked the proper column names to use. For more information, see About the mtb_server.log File.
-
In some third-party applications you can view the contents of each query, which includes all columns and parameters available to return.
-
Columns listed in bold are returned by default.
-
For ODBC queries, all columns are returned by default except where noted.
-
Columns are returned even if they are hidden in the Control Center.