You can execute the CREATE VIEW statement to create a view.

Syntax

CREATE VIEW view_name AS select_stmt         

Parameters

  • view_name: the name of the view to be created. You can use the prefix of the database name to distinguish views with the same name within different databases.
  • select_stmt: the data source of the view.

Example

Create a view named v and set its data source to the customer table.

CREATE VIEW adb_demo.v AS SELECT * FROM customer;