SET ECHO ON
SPOOL DropTables.OUT

undefine tbl_owner
define tbl_owner = &1

DROP TABLE &&tbl_owner..XC_VER;
DROP TABLE &&tbl_owner..XC_TXTDATA1;
DROP TABLE &&tbl_owner..XC_PPLIST CASCADE CONSTRAINTS;
DROP TABLE &&tbl_owner..XC_PPDATA1;
--DROP TABLE XC_SITSENS_PPI CASCADE CONSTRAINTS;
--DROP TABLE XC_PP_INSTRUCTIONS CASCADE CONSTRAINTS;
DROP TABLE &&tbl_owner..XC_GOESQC;
DROP TABLE &&tbl_owner..XC_RTUQC;
DROP TABLE &&tbl_owner..XC_DATA1;
DROP TABLE &&tbl_owner..XC_SITESENSORS CASCADE CONSTRAINTS;
DROP TABLE &&tbl_owner..XC_SITES CASCADE CONSTRAINTS;

DROP TABLE &&tbl_owner..XC_POLLGROUPS;
DROP TABLE &&tbl_owner..XC_LOG;
DROP TABLE &&tbl_owner..XC_RECORDIDS;
DROP TABLE &&tbl_owner..XC_SITESENSORSDECODE;
DROP TABLE &&tbl_owner..XC_TEMPLATES;
DROP TABLE &&tbl_owner..XC_LASTVALUES;
DROP TABLE &&tbl_owner..XC_USERS;

SPOOL OFF
