Abstract
A view is a virtual table that, in itself, doesn’t contain any data or information. All it contains is the query that the user defines when creating the view. A view is actually a named query against one or more tables. Views are used as a security measure (to restrict users to specific columns or rows), as a method of joining data from multiple tables (and presenting it as if it resides in one table), and by returning summary data instead of detailed data. Another use for a view is to provide a method of accessing the underlying data in a manner that provides the end user with a business layout. For example, you will see within this chapter a view that shows customer details along with enriched transaction details, thus making it easier for anyone interrogating your data, even someone who has no knowledge of the underlying data model, to access useful information.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2007 Robin Dewson
About this chapter
Cite this chapter
(2007). Building a View. In: Beginning SQL Server 2005 Express for Developers. Apress. https://doi.org/10.1007/978-1-4302-0329-2_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0329-2_9
Publisher Name: Apress
Print ISBN: 978-1-59059-720-0
Online ISBN: 978-1-4302-0329-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books