Creating a sequence without specifying a name?

[Josh]

In the Vertica SQL manual in the the CREATE SEQUENCE section it says "If you do not specify a sequence_name, HP Vertica assigns an internally generated name in the current schema."

Does anyone know what that means? I can't create a sequence without a name, and I can't think if any reason why you would want to anyway?!?!

Code: Select all

dbadmin=> create sequence;
ERROR 4856:  Syntax error at or near ";" at character 16
LINE 1: create sequence;
                       ^

[NorbertKrupa]

I'm trying to find out for you.