tdDrop: tdDrop

In tranlm/tdR: Teradata interaction and query package

Description

Drops tables from Teradata. Can take a JDBC connection object (conn) if provided. If no JDBC connection is provided, then a connection is attempted using the user, and password provided. If none is provided, then tries to locate a connection object (conn) in the global environment.

If a connection profile (e.g. username, password, etc.) is provided, then an attempt is made to connect to Teradata. Once the query is run, the connection is then closed. If a connection object (conn) is provided to the function (or one is found globally), then the connection remains open.

Usage

tdDrop(tables = "", ...)

Arguments

tables	String vector of Teradata tables to drop
...	Optional connection settings.

Value

An invisible object containing the tables dropped is returned.

See Also

tdConn for connection, tdDisk for disk usage, tdSpool for spool usage, tdCpu for CPU usage, and tdJoin for joining tables.

Examples

## NOT RUN ##
## Runs a quick drop query based on connection profile
# tdDrop(<tableName>, username=<username>, password=<password>, db="GCA")

## Runs query using a separately established connection
# conn = tdConn(<username>, <password>, db="GCA")
# tdDrop(<tableName>, conn=conn)

## Uses same connection, but allows code to find globally. 
# Can also drop multiple tables. 
# tdDrop(c(<table1Name>, <table2Name>))

tranlm/tdR documentation built on May 31, 2019, 7:45 p.m.