SET ECHO ON
SPOOL XCDropTables.OUT

undefine tbl_owner
define tbl_owner = &1

DROP VIEW &&tbl_owner..XC_SITESENSORS;
DROP VIEW &&tbl_owner..XC_SITES;

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 &&tbl_owner..XC_GOESQC;
DROP TABLE &&tbl_owner..XC_RTUQC;
DROP TABLE &&tbl_owner..XC_EXT_DATA1;
DROP TABLE &&tbl_owner..XC_EXT_SITESENSORS CASCADE CONSTRAINTS;
DROP TABLE &&tbl_owner..XC_EXT_SITES CASCADE CONSTRAINTS;

SPOOL OFF
