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
CREATE VIEW [dbo].[vw_CustomerAddress]ASSELECT Sales.Customer.CustomerID, Sales.Customer.AccountNumber, Person.Address.AddressLine1, Person.Address.StateProvinceID, Person.Address.City, Person.Address.PostalCode