list_schemas: List schemas in the database

View source: R/pmap_db_utilities.R

list_schemasR Documentation

List schemas in the database

Description

Function returns a character vector of all schemas in the database where PRINCIPAL_ID = 1 and where NAME is not 'dbo'; further, if a found schema has no tables, that schema name is excluded

Usage

list_schemas(engine = default_engine)

Arguments

engine

a dbConnect connection object; by default will look in namespace for default_engine

Value

character vector of schema names

Examples

list_schemas(myconnection)

lmullany/pmap_utilities documentation built on July 30, 2023, 8:54 a.m.