Id-class | R Documentation |
Objects of class Id
have a single slot name
, which is a 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
or table
argument:
dbCreateTable()
dbAppendTable()
dbReadTable()
dbWriteTable()
dbExistsTable()
dbRemoveTable()
Objects of this class are also returned from dbListObjects()
.
Id(...)
... |
Components of the hierarchy, e.g. |
# Identifies a table in a specific schema:
Id("dbo", "Customer")
# You can name the components if you want, but it's not needed
Id(table = "Customer", schema = "dbo")
# Create a SQL expression for an identifier:
dbQuoteIdentifier(ANSI(), Id("nycflights13", "flights"))
# Write a table in a specific schema:
## Not run:
dbWriteTable(con, Id("myschema", "mytable"), data.frame(a = 1))
## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.