You can query the database if you are a site administrator or have been given access to System Tools by another site administrator.

You can raise a database query using the Admin > System Tools > Ad Hoc Database Query page.

In the Ad Hoc Database Query page, select a data store, Operational Datastore or Datamart or Baseline or WEBR, type the “select” query and click Run Query.

Ad Hoc Database Query against selected database

For security reasons, the sfuser and password_history tables of the operational datastore are restricted for ad hoc querying from the Admin > System Tools > Ad Hoc Database Query page. Alternatively, use the following views, sfuser_view and password_history_view, for retrieving all other data but passwords.

You can submit read-only queries of the format:


You can use the following special keywords while drafting the query:

  • “\d” or “show tables” - To list all the tables.
  • “\d <table name> - To view the description of a specific table.
  • “select * from <table name> - To view all the contents of a specific table.



Tags for this page: site_admin_tasks