Making ad hoc queries of the database

You can make ad hoc queries on any tables in the database. Ad hoc queries let you:


This lets you you can change and delete parts of the database, which might delete some of your data or cause WellSim to crash.

Making queries

To query an SQL server database you must have Administrator permission.

From within WellSim, click Tools in the menu bar, then click Database Administration to display:

The left has a list of all tables in the currently-open database and the right is to type SQL queries.

After you have finished:

  1. Close this window.
  2. If you made any changes to the database, close WellSim and restart it again, to ensure the database is refreshed.