删除数据的sql语句

2024年2月8日发(作者：)

truncate table

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

--总表

DELETE FROM [In_Port_Log] where Hardware_Id=''

DELETE FROM [In_Port_LogError] where Hardware_Id=''

--降雨

DELETE FROM [HY_OBP_G] where STCD = '' --降雨记录表

DELETE FROM [ST_PPTN_R] where STCD = '' --降雨处理表

DELETE FROM [HY_DP_C] where STCD = '' --降雨日记录

DELETE FROM [HY_MTP_E] where STCD = '' --降雨月纪录

DELETE FROM [HY_YRP_F] where STCD = '' --降雨年纪录

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

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

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

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

--流量

DELETE FROM [ST_RIVER_R] where STCD = '' --河道处理表

DELETE FROM [HY_DQ_C] where STCD = '' --流量日记录

DELETE FROM [HY_MTQ_E] where STCD = '' --流量月纪录

DELETE FROM [HY_YRQ_F] where STCD = '' --流量年纪录

DELETE FROM [LH_Q_DAY] where STCD = '' --河道统计表:日表

DELETE FROM [LH_Q_MONTH] where STCD = '' --河道统计表:月表

DELETE FROM [LH_Q_DAY_MinMaxAvg] where STCD = '' --河道统计表:最大最小值表

--库容

DELETE FROM [ST_RSVR_R] where STCD = '' --库容处理表

DELETE FROM [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 [LH_V_MONTH] where STCD = '' --库容统计表:月表

DELETE FROM [LH_V_DAY_MinMaxAvg] where STCD = '' --库容统计表:最大最小值表

--水位

DELETE FROM [HY_DZ_C] where STCD = '' --水位日记录

DELETE FROM [HY_MTZ_E] where STCD = '' --水位月纪录

DELETE FROM [HY_YRZ_F] where STCD = '' --水位年纪录

DELETE FROM [HY_OBZ_G] where STCD = '' --水位记录表

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

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

DELETE FROM [LH_Z_DAY_JD_MinMaxAvg] 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 [Ep_YQ_JC] where STCD in ('','') --预警

DELETE FROM [LH_P_R] where STCD in ('','') --实时表

DELETE FROM [LH_P_DAY] where STCD in ('','') --降雨统计表:日表

DELETE FROM [LH_P_MONTH] where STCD in ('','') --降雨统计表:月表

--流量

DELETE FROM [ST_RIVER_R] where STCD in ('','') --河道处理表

DELETE FROM [HY_DQ_C] where STCD in ('','') --流量日记录

DELETE FROM [HY_MTQ_E] where STCD in ('','') --流量月纪录

DELETE FROM [HY_YRQ_F] where STCD in ('','') --流量年纪录

DELETE FROM [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 [ST_RSVR_R] where STCD in ('','') --库容处理表

DELETE FROM [HY_DV_C] where STCD in ('','') --库容日记录

DELETE FROM [HY_MTV_E] where STCD in ('','') --库容月纪录

DELETE FROM [HY_YRV_F] where STCD in ('','') --库容年纪录

DELETE FROM [LH_V_DAY] where STCD in ('','') --库容统计表:日表

DELETE FROM [LH_V_MONTH] where STCD in ('','') --库容统计表:月表

DELETE FROM [LH_V_DAY_MinMaxAvg] where STCD in ('','') --库容统计表:最大最小值表

--水位

DELETE FROM [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 [LH_Z_DAY_JD] where STCD in ('','') --水位统计表:日表

DELETE FROM [LH_Z_MONTH_JD] where STCD in ('','') --水位统计表:月表

DELETE FROM [LH_Z_DAY_JD_MinMaxAvg] where STCD in ('','') --水位统计表:最大最小值表

DELETE FROM [LH_Z_DAY_XD] where STCD in ('','') --水位统计表:日表

DELETE FROM [LH_Z_MONTH_XD] where STCD in ('','') --水位统计表:月表

DELETE FROM [LH_Z_DAY_XD_MinMaxAvg] where STCD in ('','') --水位统计表:最大最小值表

DELETE FROM [Ep_SQ_JC] where STCD in ('','') --预警

DELETE FROM [LH_Z_R] where STCD in ('','') --

实时表