db_schema_list {dm}

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()