Re: SQLTables does not retrieve everything

Clemens Ladisch <[email protected]> Fri, 30 Nov 2018 08:13:42 +0100

Newsgroups	gmane.comp.db.postgresql.odbc
Message-ID	<[email protected]>

Igor Korot wrote:
>     ret = SQLTables( m_hstmt, NULL, 0, NULL, 0, NULL, 0, NULL, 0 );
>
> only retrieves the tables from the current database/catalog and "public" schema.
> There is no tables/view on the INFORMATION_SCHEMA and all the system tables.

System tables are hidden by default, unless you specify them explicitly
in the TableType parameter.

The "Show System Tables" data source configuration option can change
this behaviour.

Regards,
Clemens