Save the commands in a .SQL file, ex: ClearTables.sql, say in your C:\temp folder. Contents of C:\Temp\ClearTables.sql. Then use sqlcmd to execute it as follows. Since you said the database is remote, use the following syntax (after updating for your server and database instance name).

Sqlcmd allows executing queries, T-SQL sentences and SQL Server scripts using the command line. In the previous article How to work with the command line and Azure to automate tasks, we worked with the sqlcmd in Azure. In this new chapter, we will show the following examples in a local SQL Server using sqlcmd:

sqlcmd is a command-line utility for ad hoc, interactive execution of Transact-SQL (T-SQL) statements and scripts and for automating T-SQL scripting tasks. To use sqlcmd interactively, or to build script files for sqlcmd , you should understand T-SQL.

Once the relevant database and tables are identified, it’s time to write and execute the SQL query. In this article, we’ll guide you through the process of running a SQL query, explaining every step to help you become proficient in accessing and analyzing data.