sql_list_views: List views.

Description Usage Arguments Details Value See Also Examples

Description

sql_list_views lists all views in a Microsoft SQL Server database.

Usage

1
sql_list_views(db_con, db_name, db_schema)

Arguments

db_con

Database server connection object.

db_name

Database name.

db_schema

Database schema.

Details

Will not return tables. If tables and views are desired, use sql_list_tvs.

Value

A character vector of all views.

See Also

Other sql_lists: sql_list_schemas, sql_list_tbls, sql_list_tvs

Examples

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

## End(Not run)

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