August 6, 2012 at 2:41 pm
In a sql server 2008 r2 database, I am going to increase the size of a field in a particular table called main. There is a view that uses the table called main. Thus my question is if I increase the size of one of the columns in a table that is included in a view, do I need to change anything in the view? Basically the column I am changing in the view is displayed in the view. Thus do I need to change anything about this view or will the view automatically pickup the field that is expanded? If I need to change something, can you let me know what I need to change?
August 6, 2012 at 2:47 pm
You'll want to run sp_updateview after you're done changing the underlying schema. If the view(s) are schemabound you'll have to drop and recreate them after you've made your modifications.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply