Another useful command to use is DROP. Let’s say you want to simply delete all entries in a table and recreate it. A handy way to do this is to drop the table and then re-export the schema. Again, from Figure 1, select the DROP command from the Command menu. Enter the name of the table you want to deletein this case, the table is USERSand then execute the SQL.
After dropping the table, you have to run the ant schemaexport target.