Querying table and column names

You can get a list of accessible tables and columns, based on the read ACLs for the querying user.

The following query will return the names of all tables that the querying user has read access for:

select * from oa_tables;

After you know the name of the table you want to query, you can query the names of all columns that the user has read access for. The querying user must have read access for both the table and the columns.

select * from oa_columns where table_name=‘table_name’;

Note: The oa_tables and oa_columns tables are internal ODBC tables. These tables are accessible only via the ODBC Driver.