Devart Forums

Hey guys:

when using your DLL, GetTableNames returns the tables from the DB, but the SCHEMA_NAME column is null.

Is this a implementation decision? a Bug? Any other way to retrieve table names and the schema these tables belong without asking it directly to the DB (SELECT * FROM information_schema.tables)

Thanks

--
Jackson Gomes

Hello,

To obtain tables, we use a query that returns the same data as the standard driver does. Please clarify, where can't you get data about SCHEMA_NAME?

JacksonGomes wrote:Hey guys:

when using your DLL, GetTableNames returns the tables from the DB, but the SCHEMA_NAME column is null.

Is this a implementation decision? a Bug? Any other way to retrieve table names and the schema these tables belong without asking it directly to the DB (SELECT * FROM information_schema.tables)

Thanks

--
Jackson Gomes

You should used DBX4 fetching Metadata function.


See also:
-Fetching Metadata into a dbExpress Dataset (http://docwiki.embarcadero.com/RADStudi ... ss_Dataset)

-dbExpress SetSchemaInfo is miss (Chinese) (http://grandruru.blogspot.tw/2015/04/db ... ainfo.html)

To set the Schema value, you can use the SchemaOverride parameter.