SQL Primer for R
ivo welch 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.)
If you are using RSQLite, then a lot of the obscure commands are available as R functions. In this case I think you want sqliteTableFields. Duncan Murdoch