underlying table

Changes applied to the data in a relevant underlying table are reflected in the data shown in subsequent invocations of the view.

Otherwise, the DBMS would not know how to apply the data changes to the underlying tables referred to in the cursor.

An index may be declared as UNIQUE which creates an implicit constraint on the underlying table.

Star schemas should be favored with query tools that largely expose users to the underlying table structures, and in environments where most queries are simpler in nature.

The Q programming language contains its own table query syntax called q-sql, which resembles traditional SQL but has important differences, mainly due to the fact that the underlying tables are column, rather than row, oriented.

Views can represent a subset of the data contained in a table; consequently, a view can limit the degree of exposure of the underlying tables to the outer world: a given user may have permission to query the view, while denied access to the rest of the base table.