Hi.
We have recently installed the PI SQL DAS RTQP service to allow for ODBC connections using the PI SQL Client driver. My question is, is it possible somehow to query for meta data on the different tables and columns?
For other SQL databases, it is possible with something like this:
SELECT COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME ='your_table'
But this does not work. Any suggestions?
Example of what I am looking to query:
