dbListSchemas: List all schema in database
In MARC-KC/marcR: Helpful Functions Used By The MARC-GIS Team

dbListSchemas

R Documentation

List all schema in database

Description

Searches schema in in the INFORMATION_SCHEMA.SCHEMATA table. Confirmed only to work with MS-SQL databases.

Usage

dbListSchemas(
  conn,
  rmSchemaRegex = c("sys", "sde", "^INFORMATION_SCHEMA$", "^db_\\.*")
)

Arguments

`conn`	A `DBIConnection` object, as returned by `dbConnect()`.
`rmSchemaRegex`	Character vector containing schema to avoid searching (removed schema regex). Ignores some default system level schema and schema only used by the ESRI SDE bindings that don't actually contain user created tables.

Value

A character vector of schema's in the database connections.

Author(s)

Jacob Peterson

Examples

## Not run: 

con <- connectODBC("<servername>.<databaseName>.<schemaName>")

#This is not set up to be a real example
schemas <- dbListSchema(con)

## End(Not run)

MARC-KC/marcR documentation built on June 2, 2022, 9:31 p.m.