June 8, 2009 at 2:15 am
When we make changes to the referenced columns of the base tables, the view creation should not fail.
June 8, 2009 at 2:32 am
Please be more specific about your problem?
Please read the link below in my sig for advice on Posting Best practices 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 8, 2009 at 2:38 am
Views wont fail.........
Views are a useful tool to have in your database tool arsenal. More portable than functions, more flexible than stored procedures, view can give your database more secure, more performant, and easier to use.
Give more details.......
Tanx 😀
June 8, 2009 at 8:20 am
If you create a view with schemabinding then the base tables can't be modified in a way that would break the view. However, if the view doesn't exist and you're trying to create it but there's been a change to a base table since the view definition was written... you're going to get an error.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 9, 2009 at 5:33 am
Thank u so much 🙂
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply