Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| EmpNo | Int | 4 | | no
| yes
| |
| |
| LastName | Char | 20 | | yes
|
| |
| |
| FirstName | Char | 15 | | yes
|
| |
| |
| PhoneExt | Char | 4 | | yes
|
| |
| |
| HireDate | DateTime | 8 | | yes
|
| |
| |
| Salary | Float | 8 | | yes
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| ByName | index on employee | LastName, FirstName |
|
| PRIMARY_KEY | primary key index on employee | EmpNo |
|
Dependency graph
Sample rows
| EmpNo | LastName | FirstName | PhoneExt | HireDate | Salary |
|---|
| 2
| Nelson
| Roberto
| 250
| 12/28/1988 12:00:00 AM
| 40000
|
| 4
| Young
| Bruce
| 233
| 12/28/1988 12:00:00 AM
| 55500
|
| 5
| Lambert
| Kim
| 22
| 2/6/1989 12:00:00 AM
| 25000
|
| 8
| Johnson
| Leslie
| 410
| 4/5/1989 12:00:00 AM
| 25050
|
| 9
| Forest
| Phil
| 229
| 4/17/1989 12:00:00 AM
| 25050
|
| 11
| Weston
| K. J.
| 34
| 1/17/1990 12:00:00 AM
| 33292.9375
|
| 12
| Lee
| Terri
| 256
| 5/1/1990 12:00:00 AM
| 45332
|
| 14
| Hall
| Stewart
| 227
| 6/4/1990 12:00:00 AM
| 34482.625
|
| 15
| Young
| Katherine
| 231
| 6/14/1990 12:00:00 AM
| 24400
|
| 20
| Papadopoulos
| Chris
| 887
| 1/1/1990 12:00:00 AM
| 25050
|
Code
CREATE TABLE [employee]
(
[EmpNo] INT NOT NULL,
[LastName] CHAR (20) CODE PAGE 1252,
[FirstName] CHAR (15) CODE PAGE 1252,
[PhoneExt] CHAR (4) CODE PAGE 1252,
[HireDate] DATETIME,
[Salary] FLOAT,
CONSTRAINT [PRIMARY_KEY] PRIMARY KEY ([EmpNo])
);
CREATE INDEX [ByName] ON [employee] ([LastName] ,[FirstName]);