Very good idea, thank a lot. For anyone interested, the code I found is
here:
"SELECT name FROM sqlite_master "
"WHERE type IN ('table','view') "
"UNION ALL "
"SELECT name FROM sqlite_temp_master "
"WHERE type IN ('table','view') "
"ORDER BY 1",
Thanks!
Bob Dankert
-----Original Message-----
From: Tiago Dionizio [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 12, 2004 9:09 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Get a listing of tables
You can look at the command line sources and see which SQL statement
is used to get that output (from .tables).
Tiago
On Tue, 12 Oct 2004 09:03:12 -0500, Bob Dankert <[EMAIL PROTECTED]> wrote:
> 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.
>
> Thanks!
>
> Bob Dankert
>
>
