文件名称：数据库脚本OrderDB
文件大小：13KB
文件格式：TXT
更新时间：2017-01-05 05:02:20
OrderDB
/*员工人事表*/ print'creat table Employee' go CREATE TABLE Employee( employeeNo char(8) not null /*员工编号*/ check(employeeNo like '[E][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'), employeeName varchar(10) not null, /*员工姓名*/ sex char(1) not null, /*员工性别*/ birthday datetime null, /*员工生日*/ address varchar(50) null, /*员工住址*/ telephone varchar(20) null, /*员工电话*/ hireDate datetime not null, /*雇佣日期*/ department varchar(30) not null, /*所属部门*/ headShip varchar(10) not null, /*职务*/ salary numeric(8,2) not null, /*薪水*/ constraint EmployeePK primary key (employeeNo) ) go