getTableNames: List all tables in a database schema.

In quinterpriest/DatabaseConnector: Connecting to Various Database Platforms

List all tables in a database schema.

Description

This function returns a list of all tables in a database schema.

Usage

getTableNames(connection, databaseSchema)

Arguments

connection	The connection to the database server.
databaseSchema	The name of the database schema. See details for platform-specific details.

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 character vector of table names. To ensure consistency across platforms, these table names are in upper case.

quinterpriest/DatabaseConnector documentation built on April 20, 2022, 12:48 a.m.