March 15th, 2010
Views
Posted by
admin in
B. SQL Basics
Logical tables are called views.
Here is a sample base table with column headings:
Here is a view table:
> No data is stored in a view because it is a virtual table.
The data is actually in one or more base tables.
> A view is always a single table, no matter how many
tables are the source of the view data.
> The view definition is stored in the system catalog.
> Specific columns or rows may be excluded from the view.
> A view can be used for security purposes.
