删除数据sql语句.docVIP

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 = --预警 D