existsTable: Does the table exist?

In DatabaseConnector: Connecting to Various Database Platforms

Does the table exist?

Description

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

Usage

existsTable(connection, databaseSchema, tableName)

Arguments

connection	The connection to the database server created using either connect() or dbConnect().
databaseSchema	The name of the database schema. See details for platform-specific details.
tableName	The name of the table to check.

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.

Value

A logical value indicating whether the table exits.

DatabaseConnector documentation built on May 29, 2024, 6:14 a.m.