/*==============================================================*/
/* 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资源评论
钱亚锋
- 粉丝: 107
- 资源: 1万+
最新资源
- flac-devel-1.3.0-5.el7-1.x64-86.rpm.tar.gz
- flac-libs-1.3.0-5.el7-1.x64-86.rpm.tar.gz
- C语言刷题指南和配套作业.docx
- VS2022的安装教程.pdf
- 第3节-函数.pdf
- 第4节-数组.pdf
- 第2节-分支和循环语句.pdf
- 第6节-指针.pdf
- 第5节-操作符详解.pdf
- 第8节-实用调试技巧.pdf
- 第0节-课前准备.pdf
- flannel-0.7.1-4.el7.x64-86.rpm.tar.gz
- 第5节-动态内存管理.pdf
- 第6节-文件操作.pdf
- 第1节-数据的存储.pdf
- 第3节-字符串+内存函数的介绍.pdf
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
