Another option is to use the SQL DROP statement to delete the entire table, along with its structure and indexes. This is useful if you want to get rid of a table that you no longer need.

Another way to delete data from a table using SQL DB2 is to use the DROP statement. This statement drops the table and all its associated objects, such as indexes, views, triggers, and constraints ...