|< < 8 > >|

Views

View metadata

Because a view is treated like a table, it needs metadata:

  • View name: Specified in the create view statement.

  • Column names:
    • Select a column: Keep the column name.
    • Select an expression: Provide the column name.

  • Column types: Derived from the types of the select expressions.

  • Constraints: Not "copied" to the view.

|< < 8 > >|