Microsoft® SQL Server 2012 Unleashed

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, no physical storage of data is 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 AdventureWorks2012 database:

Click here to view code image

CREATE VIEW [dbo].[vw_CustomerAddress]ASSELECT     Sales.Customer.CustomerID, Sales.Customer.AccountNumber, Person.Address.AddressLine1, Person.Address.StateProvinceID, Person.Address.City, Person.Address.PostalCode