sp_refreshview when SmartRenaming a table
flank42
Posts: 3
Several of my views show up with sp_refreshview commands in the script output from a SmartRename on a table. What are the possible reasons that these are being emitted? on 2 of the 3 views, I found a "--select * from myview" comment directly above the DDL definition; removing that comment and updating the view did not cause the refresh to go away. On the 3rd view (which does not reference any other views) I found no indication as to why it may have been included.
At first I thought "cool! its going to tell me where I've used SELECT * !" but that doesn't seem to be the case.
At first I thought "cool! its going to tell me where I've used SELECT * !" but that doesn't seem to be the case.
