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. The terms are listed in alphabetical order. 

Term

Explanation

System Table

C

Char set (character set)

MapChar set

MAPCHARSETS

Character Set

MapChar set

MAPCHARSETS

Column

definition, domain, default value
primary key
privilege
indexed
in the referential constraint
of a table in view table




COLUMNS
INDEXCOLUMNS
FOREIGNKEYCOLUMNS
VIEWCOLUMNS

Column

definition, domain, default value
primary key
privilege
indexed
in the referential constraint
of a table in view table




COLUMNS
INDEXCOLUMNS
FOREIGNKEYCOLUMNS
VIEWCOLUMNS

Computer

name
utilization

USERS
MACHINEUTILIZATION

Constraint

NOT NULL columns
primary key
on a column or table
on a domain
referential
UNIQUE


COLUMNS
CONSTRAINTS
DOMAINCONSTRAINTS
FOREIGNKEYS
INDEXES

D

Database instance

of the current database session
information

USERS
INSTANCE

Database parameters

currently valid

ACTIVECONFIGURATION

Database Procedure

name and other information
parameters

DBPROCEDURES
DBPROCPARAMS

Database session

your own and all active
roles active in the database session

SESSIONS
SESSION_ROLES

Default value

for a column
for a domain
for a role

COLUMNS
DOMAINS
ROLES

Default value

for a column
for a domain
for a role

COLUMNS
DOMAINS
ROLES

Domain

name and other information
constraint
for column definition

DOMAINS
DOMAINCONSTRAINTS
COLUMNS

Domain

name and other information
constraint
for column definition

DOMAINS
DOMAINCONSTRAINTS
COLUMNS

F

Foreign key (referential constraint)

name and other information
columns

FOREIGNKEYS
FOREIGNKEYCOLUMNS

I

Identification

internal identification of a table
internal identification of a user

TABLES
USERS

Isolation level

of the current database session

SESSIONS

K

Keys

primary key
secondary key
foreign key (referential constraint)

COLUMNS
FOREIGNKEYCOLUMNS
FOREIGNKEYS

L

Lock

currently requested

LOCKS
LOCK_WAITS

Lock

currently requested

LOCKS
LOCK_WAITS

Log Area

Utilization

LOGSTATISTICS

Log Queue

ID and other information

LOGQUEUESTATISTICS

M

MapChar set

name and other information

MAPCHARSETS

Migration (Upgrade)

log

POSTUPGRADECHECKLIST

O

Operating system

of the database instance

VERSION

P

Parameters

of a database procedure
database parameter

DBPROCPARAMS
ACTIVECONFIGURATION

Privilege

of a role
of a column
of a schema
of a table

ROLEPRIVILEGES
COLUMNS
SCHEMAPRIVILEGES
TABLES
TABLEPRIVILEGES

R

Referential constraint

name and other information
columns

FOREIGNKEYS
FOREIGNKEYCOLUMNS

Release (version)

database software

VERSION

Result table

their existence

TABLES

Role

name and other information
privileges
active in the database session

ROLES
ROLEPRIVILEGES
SESSION_ROLES

S

Schema

name and other information
privileges

SCHEMAS
SCHEMAPRIVILEGES

Sequence

current value

SEQUENCES

Server node
(computer)

name
utilization

USERS
MACHINEUTILIZATION

Session

your own and all active
roles active in the database session

SESSIONS
SESSION_ROLES

SQL mode

of the current database session

SESSIONS

Statistics

time and sample value from the last time UPDATE STATISTICS ran

TABLES

Synonym

synonyms
existence

SYNONYMS
TABLES

T

Table

name and other information
definition
synonym
privilege
view definition
constraint
referential constraint
index
view table
primary key
secondary key
triggers

TABLES
COLUMNS
SYNONYMS
TABLEPRIVILEGES
VIEWCOLUMNS
CONSTRAINTS
FOREIGNKEYS
INDEXES
VIEWS
COLUMNS
FOREIGNKEYCOLUMNS
TRIGGERS

Timeout

of the current database session

SESSIONS

Triggers

name and other information

TRIGGERS

U

UNIQUE

Index

INDEXES

Upgrade

logs

POSTUPGRADECHECKLIST

User

defined
current

USERS
SESSIONS

User

defined
current

USERS
SESSIONS

V

Version

database software and operating system

VERSION

View Table

name and other information
definition
existence
synonym
tables and columns

VIEWS
VIEWDEFS
TABLES
SYNONYMS
VIEWCOLUMNS