Tables Catalog Table: OA_TABLES
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
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.
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 |