Hi Dennis, thanks for this.

John.

On 05/05/06, Dennis Cote <[EMAIL PROTECTED]> wrote:

John Newby wrote:
> Hi, how do you get a list of all the table names within SQLite?
>
> Many thanks.
>
> John.
>
John,

From the sqlite shell use the .tables command.

From SQL code use:

  select name from sqlite_master where type = 'table';

HTH
Dennis Cote

Reply via email to