@echo off
setlocal enabledelayedexpansion
set /p servername=Enter DB Servername :
set /p instancename= Enter Server Instance (optional) : 
set /p portnumber=Enter Port Number : 
set /p dbname=Enter Database Name :
set /p username= Enter User Name :
set /p password= Enter Password :

echo ******PROCESSING QUERY******

set server= %servername%\%instancename%

if "%instancename%"=="" (
set server=%servername%
)

sqlcmd -U %username% -P %password% -S %servername%\%instancename%,%portnumber% -d %dbname% -i "%~dp0%cleartables.sql" -o "cleartables.log"

echo "check details into %~dp0%createtables.log"
EXIT /b
