Description
noneTable properties
| name | value |
|---|
| name | JESSE.STAFFG
|
| created | 3/16/2010 8:49:05 PM
|
| tablespace | USERSPACE1
|
| status | normal
|
| percent free | no statistics |
| rows | 35 |
| pages | 1 |
| average row length | 58 |
Columns
| column | datatype | default | nulls | PK | FK | UQ | comment |
|---|
| ID
| SMALLINT
(2)
|
| N
|
|
|
|
|
| NAME
| VARGRAPHIC
(9)
|
| Y
|
|
|
|
|
| DEPT
| SMALLINT
(2)
|
| Y
|
|
|
|
|
| JOB
| GRAPHIC
(5)
|
| Y
|
|
|
|
|
| YEARS
| SMALLINT
(2)
|
| Y
|
|
|
|
|
| SALARY
| DECIMAL
(9)
|
| Y
|
|
|
|
|
| COMM
| DECIMAL
(9)
|
| Y
|
|
|
|
|
Sample rows
| ID | NAME | DEPT | JOB | YEARS | SALARY | COMM |
|---|
| 10
| Sanders
| 20
| Mgr
| 7
| 18357
|
|
| 20
| Pernal
| 20
| Sales
| 8
| 18171
| 612
|
| 30
| Marenghi
| 38
| Mgr
| 5
| 17506
|
|
| 40
| O Brien
| 38
| Sales
| 6
| 18006
| 846
|
| 50
| Hanes
| 15
| Mgr
| 10
| 20659
|
|
| 60
| Quigley
| 38
| Sales
|
| 16808
| 650
|
| 70
| Rothman
| 15
| Sales
| 7
| 16502
| 1152
|
| 80
| James
| 20
| Clerk
|
| 13504
| 128
|
| 90
| Koonitz
| 42
| Sales
| 6
| 18001
| 1386
|
| 100
| Plotz
| 42
| Mgr
| 7
| 18352
|
|
Code
CREATE TABLE "JESSE "."STAFFG" (
"ID" SMALLINT NOT NULL ,
"NAME" VARGRAPHIC(9) ,
"DEPT" SMALLINT ,
"JOB" GRAPHIC(5) ,
"YEARS" SMALLINT ,
"SALARY" DECIMAL(9,0) ,
"COMM" DECIMAL(9,0) )
IN "USERSPACE1" ;