dbExistsTable-DatabaseConnectorConnection-character-method: Does a table exist?

In quinterpriest/DatabaseConnector: Connecting to Various Database Platforms

Does a table exist?

Description

Returns if a table given by name exists in the database.

\Sexpr[results=rd,stage=render]{DBI:::methods_as_rd("dbExistsTable")}

Usage

## S4 method for signature 'DatabaseConnectorConnection,character'
dbExistsTable(conn, name, database = NULL, schema = NULL, ...)

Arguments

conn	A DBIConnection object, as returned by dbConnect().
name	A character string specifying a DBMS table name.
database	Name of the database.
schema	Name of the schema.
...	Other parameters passed on to methods.

Value

dbExistsTable() returns a logical scalar, TRUE if the table or view specified by the name argument exists, FALSE otherwise.

This includes temporary tables if supported by the database.

An error is raised when calling this method for a closed or invalid connection. An error is also raised if name cannot be processed with dbQuoteIdentifier() or if this results in a non-scalar.

See Also

Other DBIConnection generics: DBIConnection-class, dbAppendTable(), dbCreateTable(), dbDataType(), dbDisconnect(), dbExecute(), dbGetException(), dbGetInfo(), dbGetQuery(), dbIsReadOnly(), dbIsValid(), dbListFields(), dbListObjects(), dbListResults(), dbListTables(), dbReadTable(), dbRemoveTable(), dbSendQuery(), dbSendStatement(), dbWriteTable()

quinterpriest/DatabaseConnector documentation built on April 20, 2022, 12:48 a.m.