Skip to contents

Get Database Schema

Usage

getDatabaseSchema(db, tableNames = NULL, tableTypes = c("TABLE", "VIEW"))

Arguments

db

full path to database (*.mdb, *.xls) or name of ODBC database

tableNames

optional. Vector of table names of tables to be included

tableTypes

types of database objects to be included. Default: c("TABLE", "VIEW")

Value

list with elements tables and relationships. Element

tables is a list o named elements with the name representing the table names and the elements being lists describing the table...