GetTableNames and Schema Name

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
JacksonGomes
Posts: 7
Joined: Tue 03 Jun 2014 00:41

GetTableNames and Schema Name

Post by JacksonGomes » Thu 24 Mar 2016 01:03

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: GetTableNames and Schema Name

Post by AlexP » Mon 28 Mar 2016 10:39

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?

Eden0928
Posts: 62
Joined: Sun 22 Apr 2012 14:08

Re: GetTableNames and Schema Name

Post by Eden0928 » Wed 11 May 2016 09:56

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)

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: GetTableNames and Schema Name

Post by AlexP » Thu 07 Jul 2016 08:05

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

Post Reply