Sql updating a view

It means that you can use the INSERT or UPDATE statement to insert or update rows of the base table through the updatable view.

In addition, you can use DELETE statement to remove rows of the underlying table through the view.

By default, the names of the columns retrieved by the .

For other options or clauses in the definition, they are added to the options or clauses of the statement that references the view, but the effect is undefined.

A view can refer to tables or views in other databases by qualifying the table or view name with the appropriate database name.

Within a database, base tables and views share the same namespace, so a base table and a view cannot have the same name.

sql updating a view-49sql updating a view-50

Views can be created from a single table, multiple tables or another view.

If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.

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 I will point out that it is dangerous to cast to varchar without a length. And if you declare a variable as varchar with no length, the length will be 1.

This is a requirement of the relational model and is referred to as relational closure.

A view is basically the relational model's way of turning a SELECT statement into a "table" that is accessible using SQL. They can consist of any combination of the following: Views are defined using SQL and are represented internally to SQL Server by a SELECT statement, not by stored data.

Leave a Reply