get_trg_table_names: Get field names for target table

In AdamCottrill/glfishr: Fetch fisheries assessment data from the FN Portal

Get field names for target table

Description

This function connects to at target database and execute a simple sql statement that will return an empty record set that contains nothing but the names of the columns in the target table. This list of field names can be used to modify or map existing data frames to match the target table so that subsequent append queries have matching schema.

Usage

get_trg_table_names(trg_db, table)

Arguments

trg_db	path to our target accdb file
table	the table name in the target database to query against

Value

character vector

Author(s)

Adam Cottrill [e-mail]

See Also

sync_fields

AdamCottrill/glfishr documentation built on Aug. 9, 2024, 5:47 p.m.