Creating a View on a Table in a Table Hierarchy

You can create a view based upon any table in a table hierarchy. For example, the following statement creates a view on the person table, which is the root supertable of the table hierarchy that Figure 32 shows:

CREATE VIEW name_view AS SELECT name FROM person

Because the person table is a supertable, the view name_view displays data from the name column of the person, employee, and sales_rep tables. To create a view that displays only data from the person table, use the ONLY keyword, as the following example shows:

CREATE VIEW name_view AS SELECT name FROM ONLY(person)

For information about how to create a typed view, see Typed Views (IDS).