Querying the Repository Using SQL

You can run standard SQL SELECT queries against the repository through the Execute Query window. If you want to execute more complex queries, you should use your DBMS query editor.

Note:

You cannot execute SQL queries while using the repository proxy.

Select Repository > Administration > Execute SQL to open the Execute Query window.

Note:
The Connect dialog box opens if you are not connected to the repository. Enter the connection parameters and click OK to connect.
Enter one or more SQL queries in the appropriate syntax for your DBMS in the window and click the Execute button.

The results of your query are displayed in the Results pane.
Click Close to exit the Execute Query dialog box.