SQL Server - Changes to a View Name not propogated through reference to it-SQL 2008

Asked By chaz d'chaz on 12-Mar-15 02:44 PM

The title pretty much says it all. In SSMS, when I change the name of a view, I don't know how to ensure that its dependents are upated with the new name, or if it's possible.

If possibe, how can it be configured and why wouldn't something like this be default behavior?

Robbe Morris replied to chaz d'chaz on 12-Mar-15 02:46 PM

SQL Server doesn't do this. You'll have to. Assuming any of your applications don't hardcode SELECT statements against the view, you could run this script which outputs the contents of stored procedures. You could do a find for the view name.

https://www.nullskull.com/articles/20030609.asp

chaz d'chaz replied to Robbe Morris on 03-Apr-15 09:21 AM

Wow. Can't believe you had to do this yourself.

Thankfully, you're a genius.

Thx again, Robbe.