On Sun, Aug 31, 2008 at 9:29 PM, ivo welch <ivowel at gmail.com> wrote: > stumped again by SQL... If I have a table named "main" in an SQLite > data base, how do I get the names of all its columns? (I have a mysql > book that claims the SHOW command does this sort of thing, but it does > not seem to work on SQLite.) look up the pragma command.