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! --j
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/