CREATE MEMORY TABLE USER_TBL(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,ACCOUNTING_GROUP VARCHAR(255),ACCOUNTING_USERNAME VARCHAR(255) NOT NULL,PASSWORD VARCHAR(255) NOT NULL,SEE_ACCOUNTING_GROUP_DATA BOOLEAN,SEE_ALL BOOLEAN,USERNAME VARCHAR(255) NOT NULL,CONSTRAINT SYS_CT_46 UNIQUE(USERNAME))
3 :
ALTER TABLE USER_TBL ALTER COLUMN ID RESTART WITH 1