[R] RSQLite equivalent of .schema?

Seth Falcon seth at userprimary.net
Thu May 13 00:36:58 CEST 2010

On 5/12/10 9:58 AM, Jonathan Greenberg wrote:
> Rhelpers:
> (Thanks for the previous help with getting a "where" statement
> working).  Now on to my next question -- our database guru has asked
> me to run ".schema" on an sqlite database, and I was wondering if
> there is an equivalent in R to do this?  Thanks!

            "select * from sqlite_master where tbl_name = 'yourTable'")

Seth Falcon | @sfalcon | http://userprimary.net/

More information about the R-help mailing list