📄 hms2000.sql
字号:
/*==============================================================*/
/* Database name: PhysicalDataModel_1 */
/* DBMS name: Microsoft SQL Server 7.x */
/* Created on: 2003-5-11 13:39:33 */
/*==============================================================*/
if exists (select 1
from sysindexes
where id = object_id('DBA.pbcatcol')
and name = 'pbcatc_x'
and indid > 0
and indid < 255)
drop index DBA.pbcatcol.pbcatc_x
go
if exists (select 1
from sysindexes
where id = object_id('DBA.pbcatedt')
and name = 'pbcate_x'
and indid > 0
and indid < 255)
drop index DBA.pbcatedt.pbcate_x
go
if exists (select 1
from sysindexes
where id = object_id('DBA.pbcatfmt')
and name = 'pbcatf_x'
and indid > 0
and indid < 255)
drop index DBA.pbcatfmt.pbcatf_x
go
if exists (select 1
from sysindexes
where id = object_id('DBA.pbcattbl')
and name = 'pbcatt_x'
and indid > 0
and indid < 255)
drop index DBA.pbcattbl.pbcatt_x
go
if exists (select 1
from sysindexes
where id = object_id('DBA.pbcatvld')
and name = 'pbcatv_x'
and indid > 0
and indid < 255)
drop index DBA.pbcatvld.pbcatv_x
go
if exists (select 1
from sysobjects
where id = object_id('DBA.aj')
and type = 'U')
drop table DBA.aj
go
if exists (select 1
from sysobjects
where id = object_id('DBA.bmdj')
and type = 'U')
drop table DBA.bmdj
go
if exists (select 1
from sysobjects
where id = object_id('DBA.bzcdwh')
and type = 'U')
drop table DBA.bzcdwh
go
if exists (select 1
from sysobjects
where id = object_id('DBA.bzhun')
and type = 'U')
drop table DBA.bzhun
go
if exists (select 1
from sysobjects
where id = object_id('DBA.caid')
and type = 'U')
drop table DBA.caid
go
if exists (select 1
from sysobjects
where id = object_id('DBA.cdlb')
and type = 'U')
drop table DBA.cdlb
go
if exists (select 1
from sysobjects
where id = object_id('DBA.cfpdjl')
and type = 'U')
drop table DBA.cfpdjl
go
if exists (select 1
from sysobjects
where id = object_id('DBA.chyu')
and type = 'U')
drop table DBA.chyu
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ct_fk')
and type = 'U')
drop table DBA.ct_fk
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ct_jg')
and type = 'U')
drop table DBA.ct_jg
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ct_jsr')
and type = 'U')
drop table DBA.ct_jsr
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ct_yd')
and type = 'U')
drop table DBA.ct_yd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ct_yyd')
and type = 'U')
drop table DBA.ct_yyd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ct_zzc')
and type = 'U')
drop table DBA.ct_zzc
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ctbzcd')
and type = 'U')
drop table DBA.ctbzcd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ctbzcd_name')
and type = 'U')
drop table DBA.ctbzcd_name
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ctdd')
and type = 'U')
drop table DBA.ctdd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ctddcd')
and type = 'U')
drop table DBA.ctddcd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ctzw')
and type = 'U')
drop table DBA.ctzw
go
if exists (select 1
from sysobjects
where id = object_id('DBA.cwjk61')
and type = 'U')
drop table DBA.cwjk61
go
if exists (select 1
from sysobjects
where id = object_id('DBA.dh_bmfj')
and type = 'U')
drop table DBA.dh_bmfj
go
if exists (select 1
from sysobjects
where id = object_id('DBA.dh_dw')
and type = 'U')
drop table DBA.dh_dw
go
if exists (select 1
from sysobjects
where id = object_id('DBA.dh_rhd')
and type = 'U')
drop table DBA.dh_rhd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.dwm')
and type = 'U')
drop table DBA.dwm
go
if exists (select 1
from sysobjects
where id = object_id('DBA.fj')
and type = 'U')
drop table DBA.fj
go
if exists (select 1
from sysobjects
where id = object_id('DBA.fjlx')
and type = 'U')
drop table DBA.fjlx
go
if exists (select 1
from sysobjects
where id = object_id('DBA.fjzh')
and type = 'U')
drop table DBA.fjzh
go
if exists (select 1
from sysobjects
where id = object_id('DBA.fkfs')
and type = 'U')
drop table DBA.fkfs
go
if exists (select 1
from sysobjects
where id = object_id('DBA.fkjl5')
and type = 'U')
drop table DBA.fkjl5
go
if exists (select 1
from sysobjects
where id = object_id('DBA.foreign1')
and type = 'U')
drop table DBA.foreign1
go
if exists (select 1
from sysobjects
where id = object_id('DBA.gbmd')
and type = 'U')
drop table DBA.gbmd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.gj')
and type = 'U')
drop table DBA.gj
go
if exists (select 1
from sysobjects
where id = object_id('DBA.gjz')
and type = 'U')
drop table DBA.gjz
go
if exists (select 1
from sysobjects
where id = object_id('DBA.gnlkxx')
and type = 'U')
drop table DBA.gnlkxx
go
if exists (select 1
from sysobjects
where id = object_id('DBA.guest')
and type = 'U')
drop table DBA.guest
go
if exists (select 1
from sysobjects
where id = object_id('DBA.gwlkxx')
and type = 'U')
drop table DBA.gwlkxx
go
if exists (select 1
from sysobjects
where id = object_id('DBA.gxzy')
and type = 'U')
drop table DBA.gxzy
go
if exists (select 1
from sysobjects
where id = object_id('DBA.gyszm5')
and type = 'U')
drop table DBA.gyszm5
go
if exists (select 1
from sysobjects
where id = object_id('DBA.gzd')
and type = 'U')
drop table DBA.gzd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.gzzh')
and type = 'U')
drop table DBA.gzzh
go
if exists (select 1
from sysobjects
where id = object_id('DBA.hdlq')
and type = 'U')
drop table DBA.hdlq
go
if exists (select 1
from sysobjects
where id = object_id('DBA.hfd')
and type = 'U')
drop table DBA.hfd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.hmd')
and type = 'U')
drop table DBA.hmd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ic_zk')
and type = 'U')
drop table DBA.ic_zk
go
if exists (select 1
from sysobjects
where id = object_id('DBA.jfgs')
and type = 'U')
drop table DBA.jfgs
go
if exists (select 1
from sysobjects
where id = object_id('DBA.jjr')
and type = 'U')
drop table DBA.jjr
go
if exists (select 1
from sysobjects
where id = object_id('DBA.jzd')
and type = 'U')
drop table DBA.jzd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.kehu')
and type = 'U')
drop table DBA.kehu
go
if exists (select 1
from sysobjects
where id = object_id('DBA.kf_wxjl')
and type = 'U')
drop table DBA.kf_wxjl
go
if exists (select 1
from sysobjects
where id = object_id('DBA.kf_wzkc')
and type = 'U')
drop table DBA.kf_wzkc
go
if exists (select 1
from sysobjects
where id = object_id('DBA.kf_wzmxz')
and type = 'U')
drop table DBA.kf_wzmxz
go
if exists (select 1
from sysobjects
where id = object_id('DBA.kfwp')
and type = 'U')
drop table DBA.kfwp
go
if exists (select 1
from sysobjects
where id = object_id('DBA.kfxfsl')
and type = 'U')
drop table DBA.kfxfsl
go
if exists (select 1
from sysobjects
where id = object_id('DBA.kfzk')
and type = 'U')
drop table DBA.kfzk
go
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -