Re: [sqlite] Get a listing of tables

[Derrell . Lipman]

"Bob Dankert" <[EMAIL PROTECTED]> writes:

> Is there any way through a sql call to get a listing of tables in
> sqlite?  I tried '.tables' as would be used at the console application,
> but this is not supported.  

This should do it:

SELECT name FROM sqlite_master WHERE type = 'table'
  UNION
  SELECT name FROM sqlite_temp_master WHERE type = 'table';