OnlineDB/EcalCondDB/sql/drop_laser.sql - master - githubmirror/cmssw

OnlineDB/EcalCondDB/sql/drop_laser.sql

15 строк351 B

Giulio Eulisse

Snapshot of CMSSW_6_2_0_pre8.

26 июн 2013, 18:12

26 июн 2013, 18:12214ab73

SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET MARKUP HTML OFF
SPOOL DELETEME.sql
select 'DROP TABLE ', TNAME, ' CASCADE CONSTRAINTS PURGE;' FROM TAB WHERE TNAME LIKE 'LMF%';
SPOOL OFF
@DELETEME
DROP TABLE RUN_LASERRUN_CONFIG_DAT;
DROP SEQUENCE lmf_run_tag_sq;
DROP SEQUENCE lmf_run_iov_sq;