SQL Query Designer

The SQL Query Designer is used to design a custom SQL query to pull information from a database.

  • Tables: Lists all tables and stored queries in the database.
  • Custom Query: Displays the query that retries information from a database. Each database type has their own version of the SQL query language. To learn how to build your own query, please refer to your database's user manual.
  • Test Query button : Click to test the custom query to ensure it will retrieve the appropriate information.
  • Results: Displays the result of the SQL query when clicking on Test Query.
 
  • Last Topic Update: 24/01/2017 09:32
  • Last Published: 7/6/2017 : 9:48 AM