A view is a virtual table, created when it’s invoked by the < view name>. The goal we had in the standards is to make it behave as much like a base table as possible.
Creating a View
The syntax of course uses the CREATE keyword because it is persisted in the schema, but not always materialized. The basic syntax is:
CREATE VIEW <view name> [(<column name list>]) [ WITH CHECK OPTION ] [ WITH <view_attribute> [ ,…n ] ] AS <table expression>
The primary purpose of a view object is to simplify programming, to allow users to access data through the