# SQLJ.REMOVE_JAR system procedure

The `SQLJ.REMOVE_JAR` system procedure removes a jar file from a database.

## Syntax

    SQLJ.REMOVE_JAR(IN QUALIFIED_JAR_NAME VARCHAR(32672),
                    IN UNDEPLOY INTEGER)

QUALIFIED_JAR_NAME
  The Derby name of the jar file, qualified by the schema name. Two examples:

      MYSCHEMA.Sample1

       -- a delimited identifier.
      MYSCHEMA."Sample2"

UNDEPLOY
  If set to 1, indicates the existence of an SQLJ deployment descriptor file. Derby ignores this argument, so it is normally set to 0.

## Execute privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this procedure by default. See "Configuring user authentication" and "Configuring user authorization" in the Derby Security Guide for more information. The database owner can grant access to other users.

## SQL example

    -- SQL statement
    CALL SQLJ.REMOVE_JAR('APP.Sample1', 0)

Parent topic: System procedures for storing jar files in a database
Related reference
SQLJ.INSTALL_JAR system procedure
SQLJ.REPLACE_JAR system procedure