tables.SRDLdb: 'tables.SRDLdb' lists the tables in a SMRU Access database

In embiuw/rSRDL: Communicate with SMRU SRDL Access (Windows only) and PostreSQL (platform independent) databases

Description

tables.SRDLdb lists the tables in a SMRU Access database

Usage

tables.SRDLdb(theDB = "ct34", thePath = "C:/MamVisAD/SMRUAccessDatabases")

Arguments

theDB	Name of database as defined in ODBC data sources
thePath	Path to folder where database is located, if running in 64-bit R.

Details

The database must first be set up as a DSN data source. Note! On Windows, by default only 32-bit data sources can be used and R (or RStudio) has to be run in 32-bit mode for these functions to work. However, functionality has now been extended (experimental for now) to run under 64-bit R. For this to worl, the path to the database must be specified.

Value

Returns a character vector with database table names

Author(s)

Martin Biuw

See Also

fields.SRDLdb for table field names, ref.SRDLdb for ref ID codes, dep.SRDLdb for retrieving deployments metadata, get.SRDLdb for querying and retrieving data from database table

Other SMRU SRDL database functions: fields.SRDLdb(), fields.SRDLpg(), ref.SRDLdb(), ref.SRDLpg(), tables.SRDLpg()

embiuw/rSRDL documentation built on Jan. 27, 2021, 8:11 p.m.