SQL - CREATE VIEW
CREATE VIEW ViewName [ (newColumnName [,...]) ]
AS subselect
[WITH [CASCADED | LOCAL] CHECK OPTION]

  • Can assign a name to each column in view.
  • If list of column names is specified, it must have same number of items as number of columns produced by subselect.
  • If omitted, each column takes name of corresponding column in subselect.
  • List must be specified if there is any ambiguity in a column name.