Re: [sqlite] List of table names?

[Dennis Cote]

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