Sql view not updating
Another limitation of views that you may be familiar with is that a view cannot be indexed. In SQL Server 2000, you can indeed create indexed views, as shown later in this chapter.
Views still, however, don't allow you to perform any of the other major SQL actions besides selecting—views can't contain syntax when defining a view.
It's a bad practice for a multitude of reasons, and going out of your way to make exceptions is inconsistent and can often encourage the wrong thing to junior developers.
Views are saved SELECT statements that allow you to operate on the results that are returned from them.
Similar performance benefits can be gained with SQL Server by basing your reports on views. A simple solution to the issue of implementing row-level and column-level security is to revoke all permissions to the underlying tables.
So, a view that returns the top 100% by sales would essentially be a sorted view.
The triggers in views are covered later in this chapter.
Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Sign up to join this community How can I do, so that view keeps its link to the table so if a change the table the view also changes, without creating it again or creating a new one. Im working with Sql Server 2008 R2 thanxs If you use two-part-naming and your script has to be run on multiple databases you will run into a problem when there are different Schemas across databases.The SQL-92 standard also mandates that views cannot be sorted with an values with a view; to support that, it also supports sorting.