Dropping Generators

From InterBase
Jump to: navigation, search

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.

Note: In previous versions of InterBase that lacked the DROP GENERATOR command, users issued a SQL statement to delete the generator from the appropriate system table. This approach is strongly discouraged now that the DROP GENERATOR command is available, since modifying system tables always carries with it the possibility of rendering the entire database unusable as a result of even a slight error or miscalculation.

Advance To: