db_table_fields: Retrieve table schema from database

View source: R/database.R

db_table_fieldsR Documentation

Retrieve table schema from database

Description

Retrieves the field names and types from a given database table

Usage

db_table_fields(ch, table_name)

Arguments

ch

Connection handle to database

Value

A dataframe containing the column names and types for the specified table

Examples

ch <- db_connect("D:/Dropbox/Work/mystic/db/MysticDB_20160208.accdb")
schema_results <- db_table_fields(ch, table_name = "Results")

walkerjeffd/myrwaR documentation built on Nov. 14, 2024, 1:25 p.m.