Properties

Name: PROJECT 
Schema: USER 
Status: NORMAL 
Create time: 16.06.2006 
Tablespace: USERSPACE1 
Index tablespace:  
Long tablespace:  
Base table schema:  
Base table:  
Rowtype schema:  
Rowtype name:  
Description:  

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  PROJNO  CHARACTER  1251         
  PROJNAME  VARCHAR  24  1251         
  DEPTNO  CHARACTER  1251         
  RESPEMP  CHARACTER  1251         
  PRSTAFF  DECIMAL         
  PRSTDATE  DATE         
  PRENDATE  DATE         
  MAJPROJ  CHARACTER  1251         
Total: 8 column(s)

Autherisations

Grantor Grantee Authorities
  SYSIBM  USER  CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE 
Total: 1 autherisation(s)

SQL

CREATE TABLE "USER    "."PROJECT"  (
          "PROJNO" CHAR(6) NOT NULL ,
          "PROJNAME" VARCHAR(24) NOT NULL ,
          "DEPTNO" CHAR(3) NOT NULL ,
          "RESPEMP" CHAR(6) NOT NULL ,
          "PRSTAFF" DECIMAL(5,2) ,
          "PRSTDATE" DATE ,
          "PRENDATE" DATE ,
          "MAJPROJ" CHAR(6) )  
         IN "USERSPACE1" ;

See Also

List of tables