title: How do I find the schema of a table in an ODBC connection by name?
body: <p>I'm using the <code>odbc</code> package to connect to a MS SQL Server</p>
  
  <pre><code>con &lt;- dbConnect(odbc::odbc(),
                   Driver   = "ODBC Driver 13 for SQL Server",
                   Server   = "server",
                   Database = "database",
                   UID      = "user",
                   PWD      = "pass",
                   Port     = 1111)
  </code></pre>
  
  <p>This server has many tables, so I'm using <code>dbListTables(con)</code> to search for the ones containing a certain substring. But once I find them I need to discover which schema they are in to be able to query them. I'm currently doing this manually (looking for the name of the table in each schema), but is there any way I can get the schema of all tables that match a string?</p>