What is a View?

A view is the ability to see something or to be seen from a particular place.

--->A View in Transact SQL is a virtual table that is created by executing a named query  that's stored as part of a database.


Schemabinding: Binds the view to the schema of the underlying table(s). When Schemabinding is specified, the base table(s) can't be modified in a way that affect the view definition.

With Encryption: is used to prevent the data from hackers. You can put a password, certificate, etc. so your view or stored procedure is safer.

With Check Option: When a row is modified through a view, the WITH CHECK OPTION makes sure that the data remains visible through the view after the modification is committed.

Distributed View: A view that joins horizontally partitioned data from a set of member tables that exist across more than one server.