Description Usage Arguments Value See Also Examples
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.
1 |
tables |
String vector of Teradata tables to drop |
... |
Optional connection settings. |
An invisible
object containing the tables dropped
is returned.
tdConn
for connection, tdDisk
for disk usage,
tdSpool
for spool usage, tdCpu
for CPU
usage, and tdJoin
for joining tables.
1 2 3 4 5 6 7 8 9 10 11 | ## 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>))
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.