Options

CREATE SEQUENCE IF NOT EXISTS -- why not?

Why does vertica conditionally dropping a sequence like this:

DROP SEQUENCE IF EXISTS <sequence_name>;

 

but it does not support conditional creation, like this?

 

CREATE SEQUENCE IF NOT EXISTS <sequence_name>;

Also, why is the conditional drop not documented anywhere in the most recent documentation online?  I'm curious whether this will be supported soon, or if neither is ever intended to be officially supported.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file