This option provides you with an easy method of dropping (deleting) a table.
On the Table Utility main menu, you can directly specify the table to be dropped or you can use the Table List function, option 1, to identify the table. Then, select option 2, Drop Table. You will be prompted with a message asking for confirmation of the DROP TABLE request as shown in Figure 46. You can then cancel the request (F12) or proceed with the drop (F10).
Figure 46. Table Utility Main Menu with Prompt for Verifying a Drop Request
+--------------------------------------------------------------------------------+
| mm/dd/yyyy CONTROL CENTER hh:mm:ss |
|*------------------------------- TABLE UTILITY -------------------------------* |
|| | |
|| DATABASE => SQLDBA | |
|| | |
|| *********************************************************************** | |
|| | |
|| OPTION => 2 1 LIST TABLES | |
|| 2 DROP TABLE | |
|| 3 REORGANIZE TABLE | |
|| 4 CREATE TABLE | |
|| 5 UPDATE STATISTICS | |
|| | |
|| *********************************************************************** | |
|| | |
|| | |
|| CREATOR => SQLMSTR | |
|| | |
|| TABLE => COUNTER | |
|| | |
|*------------------------------------------------------------------ SQC60 ----* |
| |
|PRESS F10 TO VERIFY DROP OR F12 TO CANCEL |
|ENTER F1=HELP F3=EXIT |
+--------------------------------------------------------------------------------+
When you choose the drop table option and have entered a table's CREATOR and NAME, Control Center issues a SQL DROP TABLE statement for immediate execution. If the drop is successful, message REQUEST SUCCESSFULLY PROCESSED, will be displayed; if not, an SQL error message will be displayed.