CREATE TABLE AUTOINC ( TABLENAME CHAR(18) NOT NULL , FIELD CHAR(18) NOT NULL , HIGHVAL INT NOT NULL , CONSTRAINT AUTOINC_ID_P PRIMARY KEY(TABLENAME, FIELD) ) ; COMMIT ;