existsTable

Checks whether a table exists. Accounts for surrounding escape characters.
Case insensitive.

An R 'DataBase Interface' ('DBI') compatible interface to various database platforms ('PostgreSQL', 'Oracle', 'Microsoft SQL Server',
'Amazon Redshift', 'Microsoft Parallel Database Warehouse', 'IBM Netezza', 'Apache Impala', 'Google BigQuery', 'Snowflake', 'Spark', 'SQLite',
and 'InterSystems IRIS'). Also includes support for fetching data as 'Andromeda' objects. Uses either 'Java Database Connectivity' ('JDBC') or
other 'DBI' drivers to connect to databases.

Martijn Schuemie

DatabaseConnector

Connecting to Various Database Platforms

Marc Suchard

Adam Black

Observational Health Data Science and Informatics 

Microsoft Inc. 

PostgreSQL Global Development Group 

Oracle Inc. 

Amazon Inc. 

existsTable function

<dl><dt>connection</dt>
<dd>The connection to the database server created using either
<code>connect()</code> or <code><a href="https://dbi.r-dbi.org/reference/dbConnect.html">DBI::dbConnect()</a></code>.</dd>
<dt>databaseSchema</dt>
<dd>The name of the database schema. See details for platform-specific details.</dd>
<dt>tableName</dt>
<dd>The name of the table to check.</dd></dl>

Arguments

Does the table exist? — existsTable

<dl>

<dt>connection</dt>
<dd>The connection to the database server created using either
<code>connect()</code> or <code><a href='https://dbi.r-dbi.org/reference/dbConnect.html'>DBI::dbConnect()</a></code>.</dd>


<dt>databaseSchema</dt>
<dd>The name of the database schema. See details for platform-specific details.</dd>


<dt>tableName</dt>
<dd>The name of the table to check.</dd>

</dl>

existsTable: Does the table exist?

Description

Usage

Value

Arguments

Details