"P Kishor" <punk.k...@gmail.com> wrote in message news:cdf6db501002270448s2d28ef4fm9a831fdfa7bf3...@mail.gmail.com... > On Sat, Feb 27, 2010 at 6:43 AM, Peter Rodwell > <pe...@gedackt.org> wrote: >> I'm sure this question has been asked and answered a million times, but >> I've not been able >> to find the answer. Googling for it has turned up lots of answers, none >> of which seem to >> work with SQLite: > > > http://www.google.com/search?q=sqlite+column+names > > The top four answers returned all explain how to do the above correctly. > > Use PRAGMA, or SELECT from sqlite_master >
Is there a way to use SELECT against the PRAGMA result-set? This returns an error: SELECT * FROM (PRAGMA table_info(tablename)); _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
