Optional tools

Derby supports optional tools, which you can load and unload by using the SYSCS_UTIL.SYSCS_REGISTER_TOOL system procedure as described in the Derby Reference Manual.

• Using the databaseMetaData optional tool
  The databaseMetaData optional tool creates functions and table functions corresponding to most of the methods in the java.sql.DatabaseMetaData interface.
• Using the foreignViews optional tool
  The foreignViews optional tool creates schemas, table functions, and convenience views for all user tables in a foreign database. This can be useful for bulk-importing foreign data.
• Using the luceneSupport optional tool
  The luceneSupport plugin is an optional tool that lets you use Apache Lucene to perform full-text indexing and searching of the contents of Derby text columns.