[R] SQL Primer for R

[Duncan Murdoch]

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