db_str_all: Show structure of all tables.

Description Usage Arguments Value Details Examples

View source: R/RMariaDBHelper.R

Description

Show the columns and their properties for all of the tables in a database.

Usage

1
db_str_all(conf_file = "~/.db_conf.yml")

Arguments

conf_file

(character) A file containing database connection parameters. (Default: "~/.db_conf.yml")

Value

(dataframe) The combined query results returned as a dataframe.

Details

Results from SHOW COLUMNS queries for all tables in a database will be combined into a single dataframe.

Examples

1
2
3
4
## Not run: 
db_str_all()

## End(Not run)

deohs/RMariaDBHelper documentation built on Dec. 31, 2020, 11:17 p.m.