dbListTables-OdbcConnection-method function

List remote tables and fields for an ODBC connection

dbListTables() provides names of remote tables accessible through this connection; dbListFields() provides names of columns within a table.

## S4 method for signature 'OdbcConnection'
dbListTables(
  conn,
  catalog_name = NULL,
  schema_name = NULL,
  table_name = NULL,
  table_type = NULL,
  ...
)

Arguments

• conn: A DBI::DBIConnection object, as returned by dbConnect().

• catalog_name, schema_name, table_name: Catalog, schema, and table names.

  By default, catalog_name, schema_name and table_name will automatically escape underscores to ensure that you match exactly one table. If you want to search for multiple tables using wild cards, you will need to use odbcConnectionTables() directly instead.

• table_type: The type of the table to return, the default returns all table types.

• ...: Other parameters passed on to methods.

Returns

A character vector of table or field names respectively.