title: R RODBC Show all tables
body: <p>I'm trying to catalog the structure of a MSSQL 2008 R2 database using R/RODBC.  I have set up a DSN, connected via R and used the <code>sqlTables()</code> command but this is only getting the 'system databases' info.  </p>
  
  <pre><code>library(RODBC)
  
  conn1 &lt;- odbcConnect('my_dsn')
  sqlTables(conn1)
  </code></pre>
  
  <p>However if I do this:</p>
  
  <pre><code>library(RODBC)
  
  conn1 &lt;- odbcConnect('my_dsn')
  sqlQuery('USE my_db_1')
  sqlTables(conn1)
  </code></pre>
  
  <p>I get the tables associated with the my_db_1 database.  Is there a way to see all of the databases and tables without manually typing in a separate USE statement for each?</p>