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:

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk