Views

        View is a virtual table. The columns in a view are columns from one or more physical tables in the database. View is similar to a table, but it is not stored in the database. It is a query stored as an object. User defined views are two types.

• Simple views
• Complex views

See also:

• SCHEMABINDING
• WITH CHECK OPTION
• Encrypting Views