Abstract
In SQL-89 and SQL-92 terms, a view is a standard table type, also referred to as a viewed or virtual table. It is characterized as virtual because, instead of storing a table object and allocating pages for storing data, the Firebird engine stores a metadata object description. It comprises a unique identifier, a list of column specifications, and a compiled SELECT statement for retrieving the described data into those columns at runtime.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2004 Helen Borrie and IBPhoenix
About this chapter
Cite this chapter
Borrie, H. (2004). Views. In: The Firebird Book: A Reference for Database Developers. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0743-6_24
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0743-6_24
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-279-3
Online ISBN: 978-1-4302-0743-6
eBook Packages: Springer Book Archive