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
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
