Database Terms 
To determine information about your database system, its objects, structures, status information, and so on, you have to evaluate the relevant system tables. A list of database terms and references to the system tables that can provide the information on the terms is provided below.
Term |
Explanation |
System Table |
|---|---|---|
Char set (character set) |
MapChar set |
|
Column |
Definition, domain, default value, primary key, privilege Indexed column in referential constraint for a table in the view table |
|
Computer |
Name Load |
|
Constraint |
NOT NULL columns, primary key in a column or table in a domain referential UNIQUE |
|
Database |
of the current database session, information |
|
Database parameter |
current valid |
|
Database procedure |
Name and additional information parameter |
|
Database session |
our own and all active roles in the database session active roles |
|
Default value |
for a column for a domain for a role |
|
Domain |
Name and additional information Constraint for column definition |
|
Foreign key, referential constraint |
Name and additional information Columns |
|
Identification |
Internal identification of a table Internal identification of a user |
|
Isolation level |
for current database session |
|
Key |
Primary key Secondary key Foreign key (referential constraint) |
|
Lock |
Current Requested |
|
Log area |
Load |
|
Log queue |
Identification and additional information |
|
Mapchar set |
Name and additional information |
|
Migration (upgrade) |
Log |
|
Operating system |
for the database instance |
|
Parameter |
for a database procedure Database Parameters |
|
Privilege |
for a role a column a schema a table |
|
Referential constraint |
Name and additional information Columns |
|
Release (version) |
Database software |
|
Result table |
Existence |
|
Role |
Name and additional information Privilege Active in database session |
|
Schema |
Name and additional information Privilege |
|
Sequence |
Current value |
|
Server node (computer) |
Name Load |
|
Session (database session) |
our own and all active roles in the database session active roles |
|
SQL mode |
for current database session |
|
Statistics |
Time and sample value from the last time UPDATE STATISTICS ran |
|
Synonym |
Synonyms Existence |
|
Table |
Name and additional information Definition Synonym Privilege View definition Constraint Referential constraint Index View table Primary key Secondary key Triggers |
|
Timeout |
for current database session |
|
Triggers |
Name and additional information |
|
UNIQUE |
Index |
|
Upgrade |
Logs |
|
User (database user) |
Defined current |
|
Version |
Database software and operating system |
|
View (view table) |
Name and additional information Definition Existence Synonym Tables and columns |