SQL Statements › CREATE SCHEMA › Description › Example

Example

The following example creates the schema for the authorization ID JOE, and the table named PROJECTTBL.

 EXEC SQL
     CREATE SCHEMA AUTHORIZATION JOE
     CREATE TABLE PROJECTTBL
                 (PROJECTNUM CHAR(6),
                  PROJECTNAME CHAR(24),
                  DEPTNO CHAR(3),
                  EMPNUM CHAR(6),
                  PROJSTAFF DECIMAL(5,2),
                  PRSTARTDATE DECIMAL(6),
                  PRENDDATE DECIMAL(6),
                  MAJPROJECT CHAR(6))
 END-EXEC