资源预览内容
第1页 / 共5页
第2页 / 共5页
第3页 / 共5页
第4页 / 共5页
第5页 / 共5页
亲,该文档总共5页全部预览完了,如果喜欢就下载吧!
资源描述
删除数据的删除数据的 sqlsql 语句语句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 (,) -实时表
收藏 下载该资源
网站客服QQ:2055934822
金锄头文库版权所有
经营许可证:蜀ICP备13022795号 | 川公网安备 51140202000112号