What is a view?

Essentially, a view is a stored query that selects data from specified tables. The difference between a view and a regular query executed by a user or client application is that views are stored in the database and, therefore, can have permissions defined on them.

The following are some reasons you would use views:

Views exist as objects in the database. Changes that are made to the schema of the underlying table or tables do not get reflected in the view. To include additional columns in a view, you must redefine the view to include those columns.

Related Topics