RE: [sqlite] How to read column names

[nbiggs]

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

[Dennis Cote]

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

[sqlite] How to read column names

[Eugen Stoianovici]

Is there a way of reading the names of the columns in a table? how about 
the table names in a data base?