When you delete a database, you must also delete all Java external stored procedures, Java UDFs, and JAR files.
When you delete the database, the system internally performs the following actions on Java external stored procedure-related dictionary tables. If there are Jars defined in the current database, the system:
- Updates the corresponding row for the current database in DBC.Dbase with an incremented JarLibRevision number.
- Deletes all rows in DBC.Jar_Jar_Usage where the JarDatabaseId matches the ID of the database to be deleted.
- Deletes all rows in DBC. Routine_Jar_Usage and DBC.Jars where the DatabaseId matches the ID of the database to be deleted.