[R] RSQLite equivalent of .schema?

[Seth Falcon]

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!

dbGetQuery(db,
            "select * from sqlite_master where tbl_name = 'yourTable'")


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