Deleting Master Index Database
Tables and Indexes
Scripts are provided to drop the default database tables and indexes
created in Step 8: Create the Master Index Database Structure. This is useful while testing the
master index application implementation.
To Delete Database Tables and
Indexes
-
To drop the indexes created by the Create User Indexes script:
-
Right-click Drop User Indexes.
-
Select Run.
-
On the confirmation dialog box, click OK.
-
To drop the database tables:
-
Right-click Drop Person Database.
-
Select Run.
-
On the confirmation dialog box, click OK.
-
If the database is running on the Oracle 10g platform,
open a SQL prompt and run the following command.