Thanks, Will, that's exactly what I was looking for.
Will Leshner wrote:
On Aug 8, 2005, at 5:14 AM, Matthew Gertner wrote:
I'm wondering if there is a way to get information about the format
of tables in
an existing Sqlite database. Specifically, I would like to get the
list of
columns
Try this:
select * from sqlite_master;
On 8/8/05, Will Leshner <[EMAIL PROTECTED]> wrote:
>
> On Aug 8, 2005, at 5:14 AM, Matthew Gertner wrote:
>
> > I'm wondering if there is a way to get information about the format
> > of tables in
> > an existing Sqlite database. Specifically, I would like
On Aug 8, 2005, at 5:14 AM, Matthew Gertner wrote:
I'm wondering if there is a way to get information about the format
of tables in
an existing Sqlite database. Specifically, I would like to get the
list of
columns and the data type of each column.
Check out the table_info PRAGMA on this
Hi,
I'm wondering if there is a way to get information about the format of tables in
an existing Sqlite database. Specifically, I would like to get the list of
columns and the data type of each column. Obviously we can query the
sqlite_master table and parse the CREATE TABLE statements ourselves,
4 matches
Mail list logo