This function returns a listing of tables accessible
to the connected user.
The expectation is that this is a relatively thin
wrapper around the ODBC SQLTables function call,
albeit returning a subset of the fields.
odbcConnectionTables(conn, name, ...)# S4 method for OdbcConnection,Id
odbcConnectionTables(conn, name, table_type = NULL)
# S4 method for OdbcConnection,character
odbcConnectionTables(
conn,
name,
catalog_name = NULL,
schema_name = NULL,
table_type = NULL
)
# S4 method for OdbcConnection,ANY
odbcConnectionTables(
conn,
name = NULL,
catalog_name = NULL,
schema_name = NULL,
table_type = NULL
)
# S4 method for OdbcConnection,SQL
odbcConnectionTables(conn, name, table_type = NULL)
# S4 method for Oracle,character
odbcConnectionTables(
conn,
name,
catalog_name = NULL,
schema_name = NULL,
table_type = NULL
)
data.frame with columns
table_catalog
table_schema
table_name
table_remarks
OdbcConnection
table we wish to search for
additional parameters to methods
List tables of this type, for example 'VIEW'. See odbcConnectionTableTypes for a listing of available table types for your connection.
character catalog where we wish to query for available tables
character schema where we wish to query for available tables.
It is important to note that, similar to the ODBC/API call, this method also accomodates pattern-value arguments for the catalog, schema, and table name arguments.
If extending this method, be aware that package:odbc
internally uses this method to satisfy both
DBI::dbListTables and DBI::dbExistsTable methods.
( The former also advertises pattern value arguments )
Query, rather than use SQLTables ODBC API for performance reasons on Oracle. Main functional difference between the implementation of SQLTables ( OEM driver ) and the query below is that the OEM implementation also looks through the synonyms. Given the performance reports, we sacrifice the synonym look-through for better execution time.
The ODBC documentation on SQLTables for further details.