RODBC package: How to get a logical value for the "Does the Table Exists?" query type?
<p>I am trying to transform the R/Shiny/SQL application to use data from SQL Server instead of Oracle. In the original code there is a lot of the following type conditions: If the table exists, use it as a data set, otherwise upload new data. I was looking for a counterpart of <code>dbExistsTable</code> command from <code>DBI/ROracle</code> packages, but the <code>odbcTableExists</code> is unfortunately just internal <code>RODBC</code> command not usable in <code>R</code> environment. Also a wrapper for <code>RODBC</code> package, allowing to use <code>DBI</code> type commands - <code>RODBCDBI</code> seems not working. Any ideas? 
Here is some code example:</p>

<pre><code>library(RODBC)
library(RODBCDBI)

con &lt;- odbcDriverConnect('driver={SQL
    Server};server=xx.xx.xx.xxx;database=test;uid=user;pwd=pass123')

odbcTableExists(con, "table")
</code></pre>

<p>Error: could not find function "odbcTableExists"</p>

<pre><code>dbExistsTable(con,"table")
</code></pre>

<p>Error in (function (classes, fdef, mtable)  : 
  unable to find an inherited method for function ‘dbExistsTable’ for signature ‘"RODBC", "character"’</p>