Note: Documentation for Pivotal SQLFire 1.1.x is now available at Please reference the site for the latest and most up-to-date documentation on SQLFire. The vFabric SQLFire documentation site will no longer be updated.


A SQLFire virtual table that describes installed JAR files.

See Storing and Loading JAR Files in SQLFire.
Table 1. JARS system table
Column Name Type Length Nullable Contents
SCHEMA VARCHAR 256 No The schema in which the JAR was installed.
ALIAS VARCHAR 256 No The name used to refer to this JAR file in commands such as sqlf install-jar, remove-jar, and replace-jar.
ID BIGINT 10 No The internal ID of the JAR file installation.