sql - Are Views automatically updated -

if join or cross apply 2 tables , create view, view automatically gets updated when update either of 2 tables or add records either of them?

will these new records show in view?

yes, updated, every time use them.

i think microsoft sums view quite clearly:

a view can thought of either virtual table or stored query.

http://msdn.microsoft.com/en-us/library/aa214068%28v=sql.80%29.aspx

views not automatically cached.

when select view, database has run query stored in view result set use in statement

the data 'see' in view, not stored anywhere, , generated tables on fly.

because of careful running views complex. take account view have executed before result set accessed.