datamodelr (version 0.2.1.9001)

dm_re_query: Reverse engineer query

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)
# }