删除数据的sql语句

truncate table

--删除单个站点的相关数据【只删除数据，不删除基本信息】

--总表

DELETE FROM DELETE FROM --降雨

DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM 降雨记录表

降雨处理表

--降雨日记录

--降雨月纪录 --降雨年纪录

--预警

--实时表

[In_Port_Log] where Hardware_Id=''

[In_Port_LogError] where Hardware_Id=''

[HY_OBP_G] where STCD = '' -- [ST_PPTN_R] where STCD = '' -- [HY_DP_C] where STCD = '' [HY_MTP_E] where STCD = ''

[HY_YRP_F] where STCD = '' [Ep_YQ_JC] where STCD = '' [LH_P_R] where STCD = ''

DELETE FROM [LH_P_DAY] where STCD = '' --降雨统计表:日表

DELETE FROM [LH_P_MONTH] where STCD = '' --降雨统计表:月表

--流量

DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM 小值表

--库容

DELETE FROM DELETE FROM --河道处理表

--流量日记录

--流量月纪录

--流量年纪录

--河道统计表:日表

--河道统计表:月表

--河道统计表:最大最 --库容处理表

--库容日记录

[ST_RIVER_R] where STCD = '' [HY_DQ_C] where STCD = '' [HY_MTQ_E] where STCD = '' [HY_YRQ_F] where STCD = '' [LH_Q_DAY] where STCD = '' [LH_Q_MONTH] where STCD = '' [LH_Q_DAY_MinMaxAvg] where STCD = '' [ST_RSVR_R] where STCD = '' [HY_DV_C] where STCD = ''

DELETE FROM [HY_MTV_E] where STCD = '' --库容月纪录

DELETE FROM [HY_YRV_F] where STCD = '' --库容年纪录

DELETE FROM [LH_V_DAY] where STCD = '' --库容统计表:日表

DELETE FROM DELETE FROM 小值表

--水位

DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM --库容统计表:月表

--库容统计表:最大最 --水位日记录

--水位月纪录

--水位年纪录

--水位记录表

--水位统计表:日表

--水位统计表:月表

[LH_Z_DAY_JD_MinMaxAvg] where STCD = '' --水位统计表:最

[LH_V_MONTH] where STCD = '' [LH_V_DAY_MinMaxAvg] where STCD = '' [HY_DZ_C] where STCD = '' [HY_MTZ_E] where STCD = '' [HY_YRZ_F] where STCD = '' [HY_OBZ_G] where STCD = '' [LH_Z_DAY_JD] where STCD = '' [LH_Z_MONTH_JD] where STCD = ''

大最小值表

DELETE FROM [LH_Z_DAY_XD] where STCD = '' --水位统计表:日表

DELETE FROM [LH_Z_MONTH_XD] where STCD = '' --水位统计表:月表

DELETE FROM [LH_Z_DAY_XD_MinMaxAvg] where STCD = '' 大最小值表

DELETE FROM [Ep_SQ_JC] where STCD = '' --预警

DELETE FROM [LH_Z_R] where STCD = '' --实时表

--删除多个站点的相关数据【只删除数据，不删除基本信息】

--总表

DELETE FROM [In_Port_Log] where Hardware_Id in ('','')

DELETE FROM [In_Port_LogError] where Hardware_Idin ('','')

--降雨

DELETE FROM [HY_OBP_G] where STCD in ('','') --降雨记录表

DELETE FROM [ST_PPTN_R] where STCD in ('','') --降雨处理表--水位统计表:最

DELETE FROM [HY_DP_C] where STCD in ('','') --降雨日记录

DELETE FROM [HY_MTP_E] where STCD in ('','') --降雨月纪录

DELETE FROM [HY_YRP_F] where STCD in ('','') --降雨年纪录

DELETE FROM DELETE FROM DELETE FROM DELETE FROM --流量

DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM --预警

--实时表

--降雨统计表:日表

--降雨统计表:月表

--河道处理表

--流量日记录

--流量月纪录

--流量年纪录

--河道统计表:日表

[Ep_YQ_JC] where STCD in ('','') [LH_P_R] where STCD in ('','') [LH_P_DAY] where STCD in ('','') [LH_P_MONTH] where STCD in ('','') [ST_RIVER_R] where STCD in ('','') [HY_DQ_C] where STCD in ('','') [HY_MTQ_E] where STCD in ('','') [HY_YRQ_F] where STCD in ('','') [LH_Q_DAY] where STCD in ('','')

DELETE FROM [LH_Q_MONTH] where STCD in ('','') --河道统计表:月表

DELETE FROM [LH_Q_DAY_MinMaxAvg] where STCD in ('','') --河道统计表:最大最小值表

--库容

DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM DELETE FROM 大最小值表

--水位

DELETE FROM --库容处理表

--库容日记录

--库容月纪录

--库容年纪录

--库容统计表:日表

--库容统计表:月表

[LH_V_DAY_MinMaxAvg] where STCD in ('','') --库容统计表:最 --水位日记录

[ST_RSVR_R] where STCD in ('','') [HY_DV_C] where STCD in ('','') [HY_MTV_E] where STCD in ('','') [HY_YRV_F] where STCD in ('','') [LH_V_DAY] where STCD in ('','') [LH_V_MONTH] where STCD in ('','') [HY_DZ_C] where STCD in ('','')

DELETE FROM [HY_MTZ_E] where STCD in ('','') --水位月纪录

DELETE FROM [HY_YRZ_F] where STCD in ('','') --水位年纪录

DELETE FROM [HY_OBZ_G] where STCD in ('','') --水位记录表

DELETE FROM DELETE FROM DELETE FROM 最大最小值表

DELETE FROM DELETE FROM DELETE FROM 最大最小值表

DELETE FROM DELETE FROM --水位统计表:日表

--水位统计表:月表

--水位统计表: --水位统计表:日表

--水位统计表:月表

--水位统计表: --预警

--实时表

[LH_Z_DAY_JD] where STCD in ('','') [LH_Z_MONTH_JD] where STCD in ('','') [LH_Z_DAY_JD_MinMaxAvg] where STCD in ('','') [LH_Z_DAY_XD] where STCD in ('','') [LH_Z_MONTH_XD] where STCD in ('','') [LH_Z_DAY_XD_MinMaxAvg] where STCD in ('','') [Ep_SQ_JC] where STCD in ('','') [LH_Z_R] where STCD in ('','')