Go Up to Working with Generators
To drop a generator from a database, use the following syntax:
DROP GENERATOR generator_name
The DROP GENERATOR command checks for any existing dependencies on the generator (as in triggers or UDFs) and fails if such dependencies exist. The statement fails if generator_name is not the name of a generator defined on the database. An application that tries to call a deleted generator returns runtime errors.