DB2 Create View

The DB2 Create View Tool allows users to visually create views.

For most databases, a view is simply a stored query that can be selected against similar to a table.

The Create View Tool allows the user to specify the view name and the query for the view, and then generates and/or executes the SQL needed to create the view.

The following is an example of the SQL generated from the Create View Tool

CREATE VIEW TESTUSER.E_VIEW AS select fname, lname from employee

DB2 Create View