EcalCondDB/sql/drop_laser.sql

0001 SET NEWPAGE 0
0002 SET SPACE 0
0003 SET LINESIZE 80
0004 SET PAGESIZE 0
0005 SET ECHO OFF
0006 SET FEEDBACK OFF
0007 SET HEADING OFF
0008 SET MARKUP HTML OFF
0009 SPOOL DELETEME.sql
0010 select 'DROP TABLE ', TNAME, ' CASCADE CONSTRAINTS PURGE;' FROM TAB WHERE TNAME LIKE 'LMF%';
0011 SPOOL OFF
0012 @DELETEME
0013 DROP TABLE RUN_LASERRUN_CONFIG_DAT;
0014 DROP SEQUENCE lmf_run_tag_sq;
0015 DROP SEQUENCE lmf_run_iov_sq;