SQLDropTable() function

You use the SQLDropTable() function in an InTouch QuickScript to drop a table from the database. After the QuickScript containing the SQLDropTable() function finishes, the table is no longer recognized and does not respond to any SQL statements.

Category

SQL

Syntax

[ResultCode=]SQLDropTable(ConnectionID, TableName);

Arguments

ConnectionID

Name of a memory integer tag that holds the number (ID) assigned by the SQLConnect() function to each database connection.

TableName

Name of the table that you want to drop from the database.

Example

The following example of the SQLDropTable() function drops the BATCH1 table from the database:

ResultCode=SQLDropTable(ConnectionID,"BATCH1");

See Also

SQLConnect()