Returns the names of remote objects accessible through this connection
as a data frame.
This should include temporary objects, but not all database backends
(in particular RMariaDB and RMySQL) support this.
dbListTables(), this method also enumerates tables and views
in schemas, and returns fully qualified identifiers to access these objects.
This allows exploration of all database objects available to the current
user, including those that can only be accessed by giving the full
A DBIConnection object, as returned by
A fully qualified path in the database's namespace, or
Other parameters passed on to methods.
returns a data frame
is_prefix (in that order),
optionally with other columns with a dot (
table column is of type list.
Each object in this list is suitable for use as argument in
is_prefix column is a logical.
This data frame contains one row for each object (schema, table
accessible from the prefix (if passed) or from the global namespace
(if prefix is omitted).
Tables added with
are part of the data frame,
including temporary objects if supported by the database.
As soon a table is removed from the database,
it is also removed from the data frame of database objects.
The returned names are suitable for quoting with
An error is raised when calling this method for a closed
or invalid connection.
table object can be quoted with
The result of quoting can be passed to
The unquoted results are equal to the original
(For backends it may be convenient to use the Id class, but this is
prefix column indicates if the
table value refers to a table
or a prefix.
For a call with the default
prefix = NULL, the
values that have
is_prefix == FALSE correspond to the tables
table column that have
is_prefix == TRUE can be
passed as the
prefix argument to another call to
For the data frame returned from a
dbListObject() call with the
prefix argument set, all
table values where
FALSE can be used in a call to
dbExistsTable() which returns
Other DBIConnection generics:
1 2 3 4 5 6 7
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.