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

If you drop a table with indexed columns, all the indexes are automatically dropped. If you drop a composite index, the index is dropped for all the columns that are named in that index. You cannot ...

Use the DROP TABLE command to remove a table from the database. Before you can remove a table, you must remove all its dependent objects (indexes, materialized views, etc.). table The name of the ...

Practice: CREATE/DROP Tables Now, it's time to practice the SQL commands to create and drop tables.