view

A view is a logical way of looking at data from one or more tables in the database. A view is a "virtual" table; that is, it does not actually exist in the database. A view contains pointers to the actual tables in the database. Views can be used to include a subset of information stored in one or more tables, while leaving out other information. This is especially useful if some of the columns in a table contain sensitive information. Queries are performed on a view as if the view were a normal physical table. Views are part of normal SQL Server functionality. In the AVEVA Historian, however, data can be accessed using extension tables, which differ from normal views. See also extension table.