drop_sequence

Drops an existing database sequence.

Available in a network database and requires the star$define role.

Parameters:

Name	Optional	Type	Description
sequence$	Mandatory	Text	The name of the database sequence to be dropped.
cascade$	Mandatory	Boolean	Indicates if dependent objects can be dropped.

Examples:

SELECT drop_sequence('myseq',true); -- drops sequence 'myseq' and dependent objects

SELECT drop_sequence('myseq',false); -- drops sequence 'myseq' if no dependent objects

Tips:

• The star$sequences view indicates which sequences exist.