[fpc-pascal] SQL show tables

[David B Copeland]

On Tue, 2009-01-13 at 10:37 +0000, Martin Friebe wrote:
> >   
> If you (the original poster) uses Mysql 5 or up, then "Show tables" is 
> not needed. Use the information-schema instead
> 
> SELECT table_name FROM INFORMATION_SCHEMA.TABLES  WHERE table_schema = 
> '/|db_name|/'
> 


Yes, I tried this and it works, after setting
TSQLQuery.UsePrimaryKeyAsKey := false since the table information_schema
does not have a primary key.