title: Get full "path" of SQL tables with R DBI package
body: <p>I'm new to SQL so I don't know the correct wordings, sorry for that.</p>
  <p>When I establish a connection with <code>dbConnect</code> of the <strong>DBI</strong> package, I can list all tables of the database:</p>
  <pre><code>&gt; head(dbListTables(conn))
  [1] &quot;cdw_apps&quot;                   &quot;cdw_attachments&quot;           
  [3] &quot;cdw_auditLogs&quot;              &quot;cdw_blueprints&quot;            
  [5] &quot;cdw_businessObjects&quot;        &quot;cdw_businessObjectsActions&quot;
  </code></pre>
  <p>However I can't access directly to these tables, they are nested (in some kind of &quot;folders&quot;, I don't know the wording, again).</p>
  <p>For example I have to do:</p>
  <pre><code>dbGetQuery(
    conn, 
    &quot;select top 100 * from [vxda-prod-sqldw01].[vxrd_cdw].[cdw_apps]&quot;
  )
  </code></pre>
  <p>Is it possible to list the tables with their &quot;path&quot; (I mean <code>[vxda-prod-sqldw01].[vxrd_cdw].[cdw_apps]</code> and not only <code>cdw_apps</code>)?</p>