existsTable function

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.

Returns

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.