@echo off

echo WARNING! This will delete the entire contents of your Fiper database. 
echo Please be sure you want to do this and have adequately backed up your
echo database. 
echo 
echo Note this will NOT delete any Fiper managed files which have been written
echo to the file system.  By default managed files are written to the
echo fiper/filemgr subdirectory in the server user's temp directory.  To
echo completely recover all Fiper data space, the managed files must
echo be manually removed.
echo
echo Press CTRL-C to cancel.
pause

if (%1) == () goto usage
if (%2) == () goto usage

if (%3) == () goto runLocal

sqlplus -L %1/%2@%3  @droptables.sql > droptables.log
goto end

:runLocal
sqlplus -L %1/%2  @droptables.sql > droptables.log
goto end

:usage
@echo usage: droptables username password [ dbName ]

:end

