test.script

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE NUMERO_NAME(NAME_ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,NAME VARCHAR(255),NUMERO_VALUE INTEGER,NUMERO_NUMBER INTEGER)
ALTER TABLE NUMERO_NAME ALTER COLUMN NAME_ID RESTART WITH 2
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10
SET SCHEMA PUBLIC
INSERT INTO NUMERO_NAME VALUES(1,'Raja',5,5)