Accessing Databases Using JDBC - Java Programming: Comprehensive Concepts and Techniques - page 718

To Drop Indexes and Tables in a Database

1. Enter lines 23 through 37 as shown in Figure 11-17 on page 709.
The SQL statement, DROP INDEX, is used to drop the single index on the
UserStocks table (Figure 11-21). Even though the index in this case is com-
prised of two fields, representing two foreign keys, it still is only one index.

SQL statement
DROP INDEX

table name

index name

FIGURE 11-21

2. Enter lines 38 through 47 as shown in Figure 11-17.
The SQL statement, DROP TABLE, is used to drop the UserStocks table
(Figure 11-22). Dropping the table would drop the index implicitly, if it had
not been dropped already.

SQL
statement
DROP TABLE

table
name

FIGURE 11-22