/*==============================================================*/
/* DBMS name: Microsoft SQL Server 2000 */
/* Created on: 2006-9-18 18:14:59 */
/*==============================================================*/
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'Relationship_6_FK'
and indid > 0
and indid < 255)
drop index Employee.Relationship_6_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_ap_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_ap_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_dept_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_dept_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_dip_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_dip_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_evaluation_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_evaluation_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_exp_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_exp_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_home_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_home_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_lev_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_lev_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_marriage_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_marriage_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_nation_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_nation_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_poli_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_poli_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_rel_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_rel_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_sex_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_sex_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_skill_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_skill_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_title_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_title_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_tra_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_tra_FK
go
if exists (select 1
from sysindexes
where id = object_id('Employee')
and name = 'emp_trans_FK'
and indid > 0
and indid < 255)
drop index Employee.emp_trans_FK
go
if exists (select 1
from sysindexes
where id = object_id('emp_relation')
and name = 'rel_poli_FK'
and indid > 0
and indid < 255)
drop index emp_relation.rel_poli_FK
go
if exists (select 1
from sysindexes
where id = object_id('transCode')
and name = 'trans_type_FK'
and indid > 0
and indid < 255)
drop index transCode.trans_type_FK
go
if exists (select 1
from sysobjects
where id = object_id('Department')
and type = 'U')
drop table Department
go
if exists (select 1
from sysobjects
where id = object_id('Employee')
and type = 'U')
drop table Employee
go
if exists (select 1
from sysobjects
where id = object_id('PoliCode')
and type = 'U')
drop table PoliCode
go
if exists (select 1
from sysobjects
where id = object_id('Skill')
and type = 'U')
drop table Skill
go
if exists (select 1
from sysobjects
where id = object_id('awardpunish')
and type = 'U')
drop table awardpunish
go
if exists (select 1
from sysobjects
where id = object_id('dip_code')
and type = 'U')
drop table dip_code
go
if exists (select 1
from sysobjects
where id = object_id('emp_relation')
and type = 'U')
drop table emp_relation
go
if exists (select 1
from sysobjects
where id = object_id('evaluation')
and type = 'U')
drop table evaluation
go
if exists (select 1
from sysobjects
where id = object_id('experience')
and type = 'U')
drop table experience
go
if exists (select 1
from sysobjects
where id = object_id('home_code')
and type = 'U')
drop table home_code
go
if exists (select 1
from sysobjects
where id = object_id('level_code')
and type = 'U')
drop table level_code
go
if exists (select 1
from sysobjects
where id = object_id('marriage')
and type = 'U')
drop table marriage
go
if exists (select 1
from sysobjects
where id = object_id('nation_code')
and type = 'U')
drop table nation_code
go
if exists (select 1
from sysobjects
where id = object_id('sex_code')
and type = 'U')
drop table sex_code
go
if exists (select 1
from sysobjects
where id = object_id('status_code')
and type = 'U')
drop table status_code
go
if exists (select 1
from sysobjects
where id = object_id('tansition')
and type = 'U')
drop table tansition
go
if exists (select 1
from sysobjects
where id = object_id('title_code')
and type = 'U')
drop table title_code
go
if exists (select 1
from sysobjects
where id = object_id('training')
and type = 'U')
drop table training
go
if exists (select 1
from sysobjects
where id = object_id('tr
jxc.rar （15个子文件） 
Chp14 db 
customer.sql 1KB jxc.sql 25B sale_out_item.sql 726B product.sql 966B store.sql 412B pay_code.sql 408B store_in_item.sql 726B store_in.sql 1KB sale_out.sql 1KB company.sql 1KB inventory.sql 564B crebas.sql 25KB jxc.pbt 95B examples.pbw 235B jxc.pbl 865KB资源评论
