<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Steve Jones
»
Updating Views
34 posts, Page 1 of 4
1
2
3
4
»
»»
Updating Views
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Wednesday, February 06, 2013 8:56 PM
SSC-Dedicated
Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406,
Visits: 13,722
Comments posted to this topic are about the item
Updating Views
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1416795
bitbucket-25253
bitbucket-25253
Posted Wednesday, February 06, 2013 8:57 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 5,100,
Visits: 20,194
Nice question .... but Steve had I know it was you who created the QOD would still having me wondering what the answer might be.
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #1416796
Lokesh Vij
Lokesh Vij
Posted Wednesday, February 06, 2013 9:34 PM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 12:58 AM
Points: 1,169,
Visits: 1,244
Nice question Steve!
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions
Link to my Blog Post -->
www.SQLPathy.com
Follow me
@Twitter
Post #1416800
Lokesh Vij
Lokesh Vij
Posted Wednesday, February 06, 2013 9:35 PM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 12:58 AM
Points: 1,169,
Visits: 1,244
bitbucket-25253 (2/6/2013)
Nice question .... but Steve had I know it was you who created the QOD would still having me wondering what the answer might be.
+1
Definitely, I would have also thought that there is some kind of gotcha
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions
Link to my Blog Post -->
www.SQLPathy.com
Follow me
@Twitter
Post #1416802
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, February 06, 2013 11:19 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 9,367,
Visits: 6,463
Nice question Steve, thanks.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1416812
manik123
manik123
Posted Thursday, February 07, 2013 12:21 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: 2 days ago @ 2:54 AM
Points: 152,
Visits: 154
nice quetion... EXEC sp_refreshview MyView is correct answer.
but what is the use of 'ALTER VIEW MyView ADD SCHEMABINDING'. Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view, i.e. if MyView is schema bind no one will be able to alter the dbo.MyTable table unless they drop the table.
Just think that someone drops/alters the table dbo.MyTable without paying any heed to our view. Now that would leave our view nowhere. Hence schema bind it, this will prevent any such accidents from happening.
Manik
Go fast as possible
Manik
You cannot get to the top by sitting on your bottom.
Post #1416832
Dineshbabu
Dineshbabu
Posted Thursday, February 07, 2013 12:23 AM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:50 AM
Points: 746,
Visits: 435
Nice and easy one one.
I got a second thought whether there is any database level set option to make a view referesh automatically.. finally I ensured there is no such option..
--
Dineshbabu
Desire to learn new things..
Post #1416833
demonfox
demonfox
Posted Thursday, February 07, 2013 12:36 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 6:46 PM
Points: 1,074,
Visits: 1,076
Lokesh Vij (2/6/2013)
Nice question Steve!
+1
Thanks for the question.......
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1416836
Dineshbabu
Dineshbabu
Posted Thursday, February 07, 2013 1:02 AM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:50 AM
Points: 746,
Visits: 435
Hi mani,
Thanks for spending your time to explain about schema Binding.
manik123 (2/7/2013)
If MyView is schema bind no one will be able to alter the dbo.MyTable table
unless they drop the table
.
If a view is schema bound, even dropping the table is also not possible. Either you need to drop the view or you need to remove schema binding. You can just modify the columns which is not included in view definition.
manik123 (2/7/2013)
Just think that someone drops/alters the table dbo.MyTable without paying any heed to our view. Now that would leave our view nowhere. Hence schema bind it, this will prevent any such accidents from happening.
There are few limitations in schema binding like all the objects should be within the same database. You cannot use synonyms in view definitions etc...
--
Dineshbabu
Desire to learn new things..
Post #1416845
Dineshbabu
Dineshbabu
Posted Thursday, February 07, 2013 1:03 AM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:50 AM
Points: 746,
Visits: 435
Please some one list the limitations of schema binding a view.
--
Dineshbabu
Desire to learn new things..
Post #1416846
« Prev Topic
|
Next Topic »
34 posts, Page 1 of 4
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
