dm_re_query: Reverse engineer query

In bergant/datamodelr: Define and Plot Data Model Diagrams

Description

Returns a string with SQL query to reverse engineer a database

Usage

dm_re_query(rdbms)

Arguments

rdbms

Which database ("postgres" or "sqlserver")

Value

A character string with sql query

Examples

## Not run: 
library(RPostgreSQL)
# dvdrental sample database: http://www.postgresqltutorial.com/postgresql-sample-database
con <- dbConnect(dbDriver("PostgreSQL"), dbname="dvdrental", user ="postgres")
sQuery <- dm_re_query("postgres")
dm_dvdrental <- dbGetQuery(con, sQuery)
dbDisconnect(con)

## End(Not run)

bergant/datamodelr documentation built on March 6, 2021, 5:47 a.m.