Creating a sequence without specifying a name?
Posted: Tue Mar 10, 2015 12:51 pm
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?!?!
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;
^