Description
noneTable properties
| name | value |
|---|
| name | JESSE.ORG
|
| created | 3/16/2010 8:49:03 PM
|
| tablespace | USERSPACE1
|
| status | normal
|
| percent free | no statistics |
| rows | 8 |
| pages | 1 |
| average row length | 55 |
Columns
| column | datatype | default | nulls | PK | FK | UQ | comment |
|---|
| DEPTNUMB
| SMALLINT
(2)
|
| N
|
|
|
|
|
| DEPTNAME
| VARCHAR
(14)
|
| Y
|
|
|
|
|
| MANAGER
| SMALLINT
(2)
|
| Y
|
|
|
|
|
| DIVISION
| VARCHAR
(10)
|
| Y
|
|
|
|
|
| LOCATION
| VARCHAR
(13)
|
| Y
|
|
|
|
|
Sample rows
| DEPTNUMB | DEPTNAME | MANAGER | DIVISION | LOCATION |
|---|
| 10
| Head Office
| 160
| Corporate
| New York
|
| 15
| New England
| 50
| Eastern
| Boston
|
| 20
| Mid Atlantic
| 10
| Eastern
| Washington
|
| 38
| South Atlantic
| 30
| Eastern
| Atlanta
|
| 42
| Great Lakes
| 100
| Midwest
| Chicago
|
| 51
| Plains
| 140
| Midwest
| Dallas
|
| 66
| Pacific
| 270
| Western
| San Francisco
|
| 84
| Mountain
| 290
| Western
| Denver
|
Code
CREATE TABLE "JESSE "."ORG" (
"DEPTNUMB" SMALLINT NOT NULL ,
"DEPTNAME" VARCHAR(14) ,
"MANAGER" SMALLINT ,
"DIVISION" VARCHAR(10) ,
"LOCATION" VARCHAR(13) )
IN "USERSPACE1" ;