The view is, in essence, a stored SELECT statement that masquerades as a table.The data is stored in the original tables and only "assembled" into the view when you want to look at it.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 modifying data through a view (that is, using INSERT or UPDATE statements) certain limitations exist depending upon the type of view.
The fields in a view are fields from one or more real tables in the database.
You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
If the view is updateable (not all views are) the updates are applied to the table data.
If you forget this in the future, you can always right click on the view in SQL Server Management Studio and select 'Modify' this will give you the current query, with the correct syntax for altering it.