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 ...

It is also useful if you are running SQL statements from an SQL application in another SQL-based database. The second form uses a LIKE clause to create a table that has the same column names and ...