The first object to be dealt with is the object 'table'. The user 'travel10' wants to retrieve information about the definition of his table 'customer'. For this purpose, the user 'travel10' formulates a SELECT on the system table 'domain.columns':
SELECT *
FROM DOMAIN.COLUMNS
WHERE tablename = 'CUSTOMER'
AND owner = 'TRAVEL10'
ORDER BY POS
This statement shows all column names, their data types, the column lengths, the decimal representation for numeric fields, and the privileges of the requesting user. The displayed list contains indications of whether mandatory columns are concerned and constraints or default values are defined.
The query on the table 'domain.columns' produced information about a specific table. The next query is to produce a list of tables for which the user 'travel10' has access privileges. The listed indications are essentially the owner of the table, the privileges, and statistical time information.
SELECT *
FROM DOMAIN.TABLES
ORDER BY owner,tablename
This query can be restricted according to desired criteria, e.g., to the own tables:
SELECT *
FROM DOMAIN.TABLES
WHERE owner = 'REISEN10'
ORDER BY owner,tablename