In the following table definition, column EdLev is a BYTEINT data type:
CREATE TABLE Education (Id CHAR(9) ,LastName CHAR(26) ,EdLev BYTEINT FORMAT 'Z9' CHECK (EdLev BETWEEN 0 AND 22) NOT NULL);
In the following table definition, column EdLev is a BYTEINT data type:
CREATE TABLE Education (Id CHAR(9) ,LastName CHAR(26) ,EdLev BYTEINT FORMAT 'Z9' CHECK (EdLev BETWEEN 0 AND 22) NOT NULL);