Guidelines for view names

The name for a view is an identifier of up to 128 characters.

The following example shows a view name:

Object

Name

View

MYVIEW

Use the CREATE VIEW statement to define and name a view. Unless you specifically list different column names after the view name, the column names of the view are the same as those of the underlying table. When you create different column names for your view, remember the naming conventions that you established when designing the relational database.