db_schema_list: List schemas on a database

In dm: Relational Data Models

List schemas on a database

Description

db_schema_list() lists the available schemas on the database.

Usage

db_schema_list(con, include_default = TRUE, ...)

Arguments

con	An object of class "src" or "DBIConnection".
include_default	Boolean, if TRUE (default), also the default schema on the database is included in the result
...	Passed on to the individual methods.

Details

Methods are not available for all DBMS.

Additional arguments are:

• dbname: supported for MSSQL. List schemas on a different database on the connected MSSQL-server; default: database addressed by con.

Value

A tibble with the following columns:

schema_name

the names of the schemas,

schema_owner

the schema owner names.

See Also

Other schema handling functions: db_schema_create(), db_schema_drop(), db_schema_exists()

dm documentation built on Nov. 2, 2023, 6:07 p.m.