Properties

Name: ORG 
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
  DEPTNUMB  SMALLINT         
  DEPTNAME  VARCHAR  14  1251         
  MANAGER  SMALLINT         
  DIVISION  VARCHAR  10  1251         
  LOCATION  VARCHAR  13  1251         
Total: 5 column(s)

Indexes

Name Unique rule Type Colnames Description
  USER.CC1151755924953  PRIMARY  REGULAR  DEPTNUMB   
Total: 1 index(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    "."ORG"  (
          "DEPTNUMB" SMALLINT NOT NULL ,
          "DEPTNAME" VARCHAR(14) ,
          "MANAGER" SMALLINT ,
          "DIVISION" VARCHAR(10) ,
          "LOCATION" VARCHAR(13) )  
         IN "USERSPACE1" ;

ALTER TABLE "USER    "."ORG"
    ADD CONSTRAINT "CC1151755924953" PRIMARY KEY
        ("DEPTNUMB");

See Also

List of tables