Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

REMOVE JAVA statement

Removes a class or JAR file from a database.

Syntax
REMOVE JAVA 
    { CLASS java-class-name [ , java-class-name ... ] 
    | JAR jar-name [ , jar-name ... ] }
Parameters
  • CLASS clause

    The java-class-name parameter is the name of one or more Java class to be removed. These classes must be installed classes in the current database.

  • JAR clause

    The jar-name is a single-quoted character string value of maximum length 255. Each jar-name must be equal to the jar-name of a retained JAR in the current database. Equality of jar-name is determined by the character string comparison rules of the SQL system.

Remarks

Removes a class or JAR file from the database. The class or JAR must already be installed.

Privileges

You must be the owner of the class or JAR file, or have the MANAGE ANY EXTERNAL OBJECT system privilege.

Standards
  • ANSI/ISO SQL Standard

    Not in the standard.

Example

This example removes a fictitious Java class named Demo from the current database:

REMOVE JAVA CLASS Demo;

This example removes a fictitious Java JAR named myJar from the current database:

REMOVE JAVA JAR 'myJar';