CREATE TABLE SCHEMA.TABLENAME (column1 DATATYPE, column2 DATATYPE, column3 DATATYPE) IN tablespace_name INDEX IN index_tablespace;
CREATE TABLE CORP.DIVISION (DIVNUM CHAR(3) NOT NULL, DIVNAME VARCHAR(36) NOT NULL, MGR CHAR(6) , LOCATION CHAR(16) , PRIMARY KEY(DIVNUM) ) IN DSNMAIN.TS111;
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!