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.


Search Condition Select Statement Query Plan Base Table View Definition 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Helen Borrie and IBPhoenix 2004

Authors and Affiliations

  • Helen Borrie
    • 1
  1. 1.FirebirdSQL Foundation Inc.Australia

Personalised recommendations