So we have a database where each client are their own schema. Each schema has the same set of tables. I need to be able to automate running an update script on each schema's set of tables. Currently the script is executed while in sqlcmd mode where a variable is set to a schema. There is a table that has a list of all the clients and their schemas, so is there a way to query this list and execute this script for each schema?
SQL Server 2016 Standard 13.0.5233.0
Thank you for your time.