Refreshing dependent views after a DDL change

When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of objects that depend on it. For this post, we will focus on how to update column changes on dependent views. For this type of task, there are 2 scenarios: You explicitly defined column names on the dependent views, or defined WITH SCHEMABINDING: For this case, you need to perform a find/replace task, this can be difficult to achieve since there are no native tools to do it (as far as I know). You can use third-party free tools like RedGate SQL Search or ApexSQL SQL Search , both having its pro and cons, so take a look at both tools and find out what it suits best your needs. You implicitly defined column names on dependant views: The famous SELECT * , even when this is not a best practice , it is easy to replicate changes for this case, we will show you how to do it. Setting up our example We will use WideWorldImporters