Properties

Name: EMP_RESUME 
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
  EMPNO  CHARACTER  1251         
  RESUME_FORMAT  VARCHAR  10  1251         
  RESUME  CLOB  5120  1251         
Total: 3 column(s)

Indexes

Name Unique rule Type Colnames Description
  SYSIBM.SQL060616220803090  PRIMARY  REGULAR  EMPNO, RESUME_FORMAT   
Total: 1 index(s)

Referenced tables

Table Foreign key Primary key
  USER.EMPLOYEE  CC1151778995891  CC1151778928062 
Total: 1 referenced table(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    "."EMP_RESUME"  (
          "EMPNO" CHAR(6) NOT NULL ,
          "RESUME_FORMAT" VARCHAR(10) NOT NULL ,
          "RESUME" CLOB(5120) LOGGED NOT COMPACT )  
         IN "USERSPACE1" ;

ALTER TABLE "USER    "."EMP_RESUME"
    ADD PRIMARY KEY
        ("EMPNO",
         "RESUME_FORMAT");


ALTER TABLE "USER    "."EMP_RESUME"
    ADD CONSTRAINT "CC1151778995891" FOREIGN KEY
        ("EMPNO")
    REFERENCES "USER    "."EMPLOYEE"
        ("EMPNO")
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
    ENFORCED
    ENABLE QUERY OPTIMIZATION;

See Also

List of tables