Administrators can run basic SQL SELECT queries against the repository through the Execute Query window. For more complex queries, you should use your DBMS query editor.
Note:
You cannot execute SQL queries when connecting to the repository via the repository proxy.
Connect to the repository and then select Repository > Administration > Execute SQL to open the Execute Query window.
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.