Competition: What’s your favorite Redgate tool? Enter now.

sp_refreshview when SmartRenaming a table

flank42flank42 Posts: 3
edited November 13, 2007 9:05AM in SQL Refactor Previous Versions
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.
Sign In or Register to comment.