asparagus asparagus - 3 years ago 94
SQL Question

"SQL command not properly ended" by creating a sequence

CREATE SEQUENCE seq_mitarbeiterid
INCREMENT BY 1
START WITH 0
MAX VALUE 9999
NOCACHE
NOCYCLE;


I can't see what's wrong with that statement or why I get that error message.

Thanks in advance.

Answer Source

From the error, it looks like you are using Oracle. If so, there is a syntax error near MAX VALUE - which should be MAXVALUE.

CREATE SEQUENCE seq_mitarbeiterid
INCREMENT BY 1
START WITH 0
MAXVALUE 9999    -- Here
NOCACHE
NOCYCLE;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download