Identify rows with given table name, database name, or schema in the MetaData table in the R&A's documentation database.

Identify rows with given table name, database name, or schema in the MetaData table in the R&A's documentation database.

id_tables_in_dbs(.table_name, .server_name, .database_name, .schema)

Arguments

.table_name

the name of a table that may be located somewhere, as a quoted string

.server_name

the name of the server that hosts the database

.database_name

the name of a database in the warehouse , as a quoted string

.schema

the name of a schema in the warehouse, as a quoted string

Value

a tibble with all unique table, schema, database, and server combinations found in the MetaData table

Examples

if (FALSE) {
library(ideadata)

id_tables_in_dbs("Students")
}