Extending Informix-Universal Server: Data Types
Chapter 3: Creating User-Defined Casts
Home
Contents
Index
Master Index
New Book
Dropping a Cast
The
DROP CAST
statement removes the definition for a cast from the database. Universal Server removes the class definition from the
syscasts
system catalog table. You must be the owner of the cast or the
DBA
to drop its definition from the database.
Warning:
Do not drop the system-defined casts, which are owned by user
informix
. The database server uses system-defined casts for automatic conversions between built-in data types. Do not drop opaque-type support functions, which serve as casts, if you still want to use the opaque data type in the database.
If you are the owner (the person who created the cast) or the
DBA
, the following statements remove the casts between the
DECIMAL
and
percent
data types from the database:
DROP CAST (decimal AS percent);
DROP CAST (percent AS decimal);
Dropping a cast has no effect on the function associated with the cast. Use the
DROP FUNCTION
statement to remove a function from the database.
Extending Informix-Universal Server: Data Types
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
