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