Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Employees
- (
- EmpID int not null,
- EmpFirst varchar(30) not null,
- EmpLast varchar(30) not null,
- WareHouseID varchar(5) not null,
- SSN varchar(9) not null,
- DOB datetime not null,
- StartDate datetime not null,
- EndDate datetime null,
- Address varchar(40) not null,
- City varchar(30) not null,
- State varchar(2) not null,
- ZIP varchar(10) not null,
- PositionID int not null,
- Memo Longtext null,
- Phone varchar(15) not null,
- Cell varchar(15) not null,
- Salary Decimal(19,4) null,
- HourlyRate decimal(19,4) null,
- Review datetime null,
- constraint pk_Employees primary key(EmpID asc)
- )
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement