SQL Query

In iMIS you can run SQL queries to view the data in the tables.

  1. From the menu bar, select Utilities > SQL Query to open the SQL Query window.
  2. Click New.
  3. Enter the SQL query in the SQL Command Text box. In the following example, we are selecting all the data from the Name table.
  4. Click Execute. iMIS displays the results of the query in the Command Result box.
  5. To clear the screen:
  6. Click Clear Query to clear the SQL command.
  7. Clear Clear Result to clear the results.

From the menu bar, select Utilities > SQL Query