Dropping Tables
SQLDropTable drops tables from a database. An alternative, using raw SQL, is demonstrated in
"Dropping Tables with Raw SQL".
If you find that the examples in this tutorial do not work as shown, you may need to install or restore the example database with the
DatabaseExamples` package, as described in
"Using the Example Databases".
The result of
SQLDropTable is an integer specifying the number of rows affected by the query.
Dropping a table from a database.
Here is an example that drops a table. This loads
DatabaseLink and connects to the
demo database.
A new table,
TEST, is created and data is inserted.
| Out[5]= |  |
SQLTableNames verifies that the table is removed from the database.
| Out[6]= |  |
SQLDropTable accepts one option.
| | |
| "Timeout" | Automatic | set the timeout for a query |
Option of SQLDropTable.
The option
"Timeout" can be used to cancel a query if it takes too long to execute.
This closes the connection.
