FirebirdSQL logo
 SEQUENCECOLLATION 

CREATE OR ALTER EXCEPTION Example

Changing the message for the exception E_LARGE_VALUE
CREATE OR ALTER EXCEPTION E_LARGE_VALUE
  'The value is higher than the permitted range 0 to 32,765';
See also

[fblangref50-ddl-exception-create], [fblangref50-ddl-exception-alter], [fblangref50-ddl-exception-recreate]

DROP EXCEPTION

Drops a custom exception

Available in

DSQL, ESQL

Syntax
DROP EXCEPTION exception_name
Table 1. DROP EXCEPTION Statement Parameter
Parameter Description

exception_name

Exception name

The statement DROP EXCEPTION is used to delete an exception.Any dependencies on the exception will cause the statement to fail, and the exception will not be deleted.