How to delete a DB2 table TAB1?

DB2DatabaseBig Data Analytics

We can delete the unused tables in the DB2. However, we must keep in mind that if we delete a table then all the indexes associated with the table are also dropped. Moreover, the triggers and views for the deleted table will become inaccessible. To delete any table in DB2, we can issue below command.

DROP TABLE DBSET1.TAB1

The DROP TABLE reserved word will be followed by the name of the table qualified by the database. The mentioned table will be deleted from the DB2 permanently.

raja
Published on 12-Sep-2020 14:19:48
Advertisements