Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| IND_CODE | Int | 4 | | yes
|
| |
| |
| IND_NAME | Char | 5 | | yes
|
| |
| |
| LONG_NAME | Char | 20 | | yes
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| IND_CODE | index on industry | IND_CODE |
|
Dependency graph
Sample rows
| IND_CODE | IND_NAME | LONG_NAME |
|---|
| 3579
| SoftW
| Computer Software
|
| 3710
| Auto
| Auto & Truck
|
| 3720
| Aero
| Aerospace/Defense
|
| 7000
| Hotel
| Hotel/Gaming
|
| 8000
| Med
| Medical Services
|
| 3573
| Comp
| Computer Hardware
|
| 4810
| Tele
| Telecommunications
|
Code
CREATE TABLE [industry]
(
[IND_CODE] INT,
[IND_NAME] CHAR (5) CODE PAGE 1252,
[LONG_NAME] CHAR (20) CODE PAGE 1252
);
CREATE INDEX [IND_CODE] ON [industry] ([IND_CODE]);