Sybase Adaptive Server Anywhere - REMOVE Statement

Chapter 9 SQL Statements
589
REMOVE 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.
REMOVE JAVA classes_to_remove
classes_to_remove
:
CLASS
java_class_name [, java_class_name , …]
| JAR
jar_name [, jar_name , …]
Must have DBA authority.
Not supported on Windows CE.
Removes a class or jar file from the database.
CLASS 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 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.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise. A similar
feature is available in an Adaptive Server Enterprise-compatible manner
using nested transactions.
♦ The following statement removes a Java class named Demo from the
current database.
REMOVE JAVA CLASS Demo
Function
Syntax
Permissions
Description
Parameters
Standards and
compatibility
Examples