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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » Using SQL » SQL statements » SQL statements (P-Z)

 

REMOVE JAVA statement

Use this statement to remove a class or a jar file from a database. When a class is removed it is no longer available for use as a column or variable type.

The class or jar must already be installed.

Syntax
REMOVE JAVA classes-to-remove
classes-to-remove :
  CLASS java-class-name, ... | JAR 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 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.

Permissions
  • Must have DBA authority.

  • Not supported on Windows Mobile.

Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement removes a Java class named Demo from the current database.

REMOVE JAVA CLASS Demo;