Does the table exist?

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

existsTable(connection, databaseSchema, tableName)

Arguments

connection

The connection to the database server created using either connect() or DBI::dbConnect().

databaseSchema

The name of the database schema. See details for platform-specific details.

tableName

The name of the table to check.

Value

A logical value indicating whether the table exits.

Details

The databaseSchema argument is interpreted differently according to the different platforms: SQL Server and PDW: The databaseSchema schema should specify both the database and the schema, e.g. 'my_database.dbo'. Impala: the databaseSchema should specify the database. Oracle: The databaseSchema should specify the Oracle 'user'. All other : The databaseSchema should specify the schema.