CREATE VIEW is used to create a new view of one or more tables. See Chapter 22, "Using Views," for more information.
• Input
CREATE [OR REPLACE] VIEW viewname AS SELECT ...;