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 > Given the SQLite databse "mydb" containing table "mytable", what is the > correct SQL command to retrieve the column names from said table? > > Peter. > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
