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 s
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
Hi, how do you get a list of all the table names within SQLite?
Many thanks.
John.
3 matches
Mail list logo