Definition of Views
Views are a logical way of viewing data in the underlying physical tables. They are tied to a SELECT
statement that retrieves data from one or more tables or views in the same database or a different database. In most cases, there is no physical storage of data associated with the view, and the SELECT
that is associated with the view is run dynamically whenever the view is referenced.
The following T-SQL statement can be used to create a simple view in the Adventureworks2008
database:
The vw_CustomerAddress
view in this example selects from four different tables in the Adventureworks2008
database: Sales.Customer
, Person.Person ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.