Edit

Share via

rxSqlServerDropTable: rxSqlServerDropTable

  • Article

Description

Execute a SQL statement that drops a table or checks for existence.

Usage

  rxSqlServerTableExists(table, connectionString = NULL)
  rxSqlServerDropTable(table, connectionString = NULL)

Arguments

table

character string specifying a table name or an RxSqlServerDatadata source that has the table specified.

connectionString

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.

Details

An SQL query is passed to the ODBC driver.

Value

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).

Author(s)

Microsoft Corporation Microsoft Technical Support

See Also

RxInSqlServer, RxSqlServerData.

Examples


 ## Not run:

# With an RxInSqlServer active compute context
tempTable <- "rxTempTest"
if (rxSqlServerTableExists(tempTable)) rxSqlServerDropTable(tempTable)
## End(Not run)