Re: [sqlite] getting list of column names

> > http://www.sqlite.org/pragma.html#pragma_table_info > I wasn't aware of that. Thank you very much! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] getting list of column names

On Jul 10, 2011, at 8:41 PM, e-mail mgbg25171 wrote: > Is there a better way to do this? pragma table_info http://www.sqlite.org/pragma.html#pragma_table_info ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] getting list of column names

Here's what I'm doing to get a list of column names as a first step in my "add column" routine. I see that limit 1 isn't limiting the output to the first row ie the column names... like it did when I used SQLitening. Is there a better way to do this? Any advice much appreciated. int