Updating a view in sql
As far as the user is concerned, the view looks just like a table.The following Transact-SQL statement selects all the data for the view shown in Listing 9.1, sorting the result set on the Company Name column: statement wouldn't have to change. Company Name Views are created inside individual databases, however, views can reference tables and views in other databases or even on other servers (if the view is defined using distributed queries).When the lock is granted, and there are no active users of the view, the Database Engine deletes all copies of the view from the procedure cache.
This metadata enables the client-side APIs to implement updatable client-side cursors.
Note In the columns for the view, the permissions for a column name apply across a CREATE VIEW or ALTER VIEW statement, regardless of the source of the underlying data.
For example, if permissions are granted on the Sales Order ID column in a CREATE VIEW statement, an ALTER VIEW statement can rename the Sales Order ID column, such as to Order Ref, and still have the permissions associated with the view using Sales Order ID.
When SCHEMABINDING is specified, the base tables cannot be modified in a way that would affect the view definition.
The view definition itself must first be modified or dropped to remove dependencies on the table to be modified.