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 a named query that can be used against one or more tables. Views are used as a security measure by restricting users to accessing only certain columns or rows from an underlying table, as a method of joining data from multiple tables and presenting it as if that data resided in one table, and as a method of returning summary data instead of detailed data.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Robin Dewson
About this chapter
Cite this chapter
Dewson, R. (2015). Building a View. In: Beginning SQL Server for Developers. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0280-7_13
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0280-7_13
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0281-4
Online ISBN: 978-1-4842-0280-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books