Posted by Roy Harvey (SQL Server MVP) on 10/22/07 13:49

On Mon, 22 Oct 2007 05:26:37 -0700, Phung <purwa@purwadhika.com>
wrote:

>Hi friend ! i want to ask you about view. will the view data be
>updated automatically when we insert or update the physical table or
>it is updated when we execute the view ?

The view data IS the table data. When you reference a view in a
SELECT, the SELECT command inside the view and the SELECT (or other
command) using the view are combined into a more complex SELECT, and
the underlying tables are read.

Roy Harvey
Beacon Falls, CT

[Back to original message]