skip to main content
Schema Management : Schema Objects : Tables Catalog Table: OA_TABLES
 

Tables Catalog Table: OA_TABLES

The OA_TABLES table contains the table name, table owner, table type, and descriptions of all tables accessible when connecting to the associated IP. This table provides information for the SQLTables ODBC call. The cursor opened when information about tables is returned must match the column sequence and type in the following table.
 
Table 123: Definition of OA_TABLES Table 
Column Name
Type
Len
Description
TABLE_QUALIFIER
WVARCHAR
128
Name of the database, normally SCHEMA, in which the table falls. Can be used to distribute tables into physically different databases.
TABLE_OWNER
WVARCHAR
128
The owner of the table. This entry must match the TABLE_OWNER entry in the OA_COLUMNS table.
TABLE_NAME
WVARCHAR
128
The name that the end user will use to refer to the table.
TABLE_TYPE
WVARCHAR
128
Exposes the type of table. Valid settings are:
SYSTEM TABLE – the system table.
TABLE – this is a normal user table.
VIEW – the object is a view.
REMARKS
WCHAR
254
The description of the table