Refer to a table nested in a hierarchy (e.g. within a schema)
Objects of class Id
have a single slot name
, which is a named
character vector.
The dbQuoteIdentifier()
method converts Id
objects to strings.
Support for Id
objects depends on the database backend.
They can be used in the following methods as name
argument:
dbRemoveTable()
Objects of this class are also returned from dbListObjects()
.
Id(...)
... |
Components of the hierarchy, e.g. |
Id(schema = "dbo", table = "Customer") dbQuoteIdentifier(ANSI(), Id(schema = "nycflights13", table = "flights")) Id(cluster = "mycluster", catalog = "mycatalog", schema = "myschema", table = "mytable")
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.