Clears temp-table definitions and removes temp-table data.

Return type: LOGICAL

Applies to: Temp-table object handle

Syntax

CLEAR ( )

This method empties the temp-table and removes all its definitional data (field and index definitions and pending saved data). This puts the temp-table object into the CLEAR state, as opposed to the UNPREPARED or PREPARED state. Calling any method after this one changes the state to UNPREPARED.

If an error occurs while executing the CLEAR( ) method, the method returns FALSE. Otherwise, it returns TRUE.