Subj : Selecting User Created Tables from SQL DB
To   : borland.public.cpp.borlandcpp
From : Cenk
Date : Sat Oct 01 2005 12:32 am

Hi guys,

i m trying to get the names of tables which i created before. And i m using
the query below:

TableQuery->SQL->Add ("SELECT TABLE_NAME AS TNAME FROM
INFORMATION_SCHEMA.TABLES WHERE (TABLE_TYPE = 'BASE TABLE')");
TableQuery->Open ();

But unfortunately, SQL Explorer could not bring the names. When i add
COUNT(TABLE_NAME) to the statement it brings the count number! Would you
please help me? thanks

Cenk

.