SQLClearTable() function
- Last UpdatedJun 17, 2024
- 1 minute read
The SQLClearTable() function deletes all records from a table. It does not delete the table from the database.
Category
SQL
Syntax
[ResultCode=]SQLClearTable(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 in which all records are cleared.
Example
In the following example, the SQLClearTable() function clears all records from the BATCH1 table.
ResultCode=SQLClearTable(ConnectionID,"BATCH1");
See Also
SQLConnect(), SQLClearStatement()