Run sample SQL queries
- Last UpdatedSep 29, 2022
- 1 minute read
- PI System
- PI SQL Commander Lite 2021
- Developer
For both Data Archive and PI AF server, a sample SQL query is included for each table in the catalogs. Use these queries to explore PI SQL Commander Lite functionality, or edit and save these queries to use as a custom query.
-
Connect to a data source and expand the schema.
-
Right-click an object in the catalog that represents a table, view, or function, and then select Execute Predefined Query.
The sample query results and messages open in a new tab in the query editor.