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()ordbConnect().- 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.