List all tables in a database schema.
This function returns a list of all tables in a database schema.
getTableNames(connection, databaseSchema)
connection |
The connection to the database server. |
databaseSchema |
The name of the database schema. See details for platform-specific 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'. PostgreSQL and Redshift: The databaseSchema should specify the schema. Oracle:
The databaseSchema should specify the Oracle 'user'. MySql and Impala: The databaseSchema should
specify the database.
A character vector of table names. To ensure consistency across platforms, these table names are in upper case.
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.