User Tools

Site Tools


how_to:writesqlqueries

This is an old revision of the document!


How to write SQL Queries to explore database

Once you are opened an MSI session, you can explore the database by creating SQL queries. Information on MSI database and its model is available here .

To create a new SQL file from an hEIDI project, select the File > New File menu, then choose SQL File under the Other Category.
It is also possible to view data from a table like this:

  • In the Services Window, select a database connection
  • Expand the schema node of your choice, then the TABLES node
  • Select a table, right-click and choose View data to display table values

SQL queries sample

FIXME Add an example here FIXME

how_to/writesqlqueries.1262622975.txt.gz · Last modified: 2010/01/04 17:36 by 132.168.74.230