Re: [sqlite] List of table names?

2006-05-05 Thread John Newby
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

Re: [sqlite] List of table names?

2006-05-05 Thread 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

[sqlite] List of table names?

2006-05-05 Thread John Newby
Hi, how do you get a list of all the table names within SQLite? Many thanks. John.