From wiki_dbSQWare
Jump to: navigation, search


It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwing_% or isqwing_% are specific for Ingres.
Installation guide for SQWareRepository for Ingres

Naming convention

All specific objects for Ingres are named with prefixes:

  • tsqwing_% : for tables
  • isqwing_% : for index
  • isqwing_%_u : for uniques
  • isqwing_%_pk : for primary key

Nuvola apps important.png
Do not change the standard tables of the tool. For your custom objects, use another name convention than dbSQWare.

This will facilitate version upgrades.

Specific database content for Ingres


This table contains : ...
Desc of tsqwing_VolDb :

Field Type
dbalias varchar(80)
database_name varchar(80)
gather_date datetime
size_db decimal(12,2)