sql_list_tvs: List tables and views.

Description Usage Arguments Value See Also Examples

Description

sql_list_tvs lists all tables and views in a Microsoft SQL Server database.

Usage

1
sql_list_tvs(db_con, db_name, db_schema)

Arguments

db_con

Database server connection object.

db_name

Database name.

db_schema

Database schema.

Value

A character vector of all tables and views.

See Also

Other sql_lists: sql_list_schemas, sql_list_tbls, sql_list_views

Examples

1
2
3
4
5
6
7
## Not run: 
con <- RSQLServer::src_sqlserver(server = "dbserver_dbname", file = "~/.sql.yaml")
dbserver_tvs <- sql_list_tvs(db_con = con,
                             db_name = "dbname",
                             db_schema = "dbschema")

## End(Not run)

curtisalexander/CRAmisc documentation built on May 14, 2019, 12:52 p.m.