rxSqlServerDropTable: rxSqlServerDropTable
Execute a SQL statement that drops a table or checks for existence.
rxSqlServerTableExists(table, connectionString = NULL)
rxSqlServerDropTable(table, connectionString = NULL)
character string specifying a table name or an RxSqlServerDatadata source that has the table
specified.
NULL
or character string specifying the connection string. If NULL
, the connection string from the currently active compute context will be used if available.
Additional arguments to be passed through.
An SQL query is passed to the ODBC driver.
rxSqlServerTableExists
returns TRUE
is the table exists, FALSE
otherwise.
rxSqlServerDropTable
returns TRUE
is the table is successfully dropped,
FALSE
otherwise (for example, if the table did not exist).
Microsoft Corporation Microsoft Technical Support
RxInSqlServer, RxSqlServerData.
## Not run:
# With an RxInSqlServer active compute context
tempTable <- "rxTempTest"
if (rxSqlServerTableExists(tempTable)) rxSqlServerDropTable(tempTable)
## End(Not run)