RE: [sqlite] How to read column names
select name from sqlite_master where type='table' That will get you the names of tables in the database. -Original Message- From: Eugen Stoianovici [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 3:57 PM To: sqlite-users@sqlite.org Subject: [sqlite] How to read column names Is there a way of reading the names of the columns in a table? how about the table names in a data base?
Re: [sqlite] How to read column names
Eugen Stoianovici wrote: Is there a way of reading the names of the columns in a table? how about the table names in a data base? Eugen, This will give you the table names: select name from sqlite_master where type = 'table'; and this will give you the columns in that table: pragam table_info(table_name); HTH Dennis Cote