Register Login

Difference between Database View and Projection View

Updated May 18, 2018

Database View vs Projection View

View is an imaginary table. It does not lies under database. Actually the View data is stored in database tables only. Views are filled during runtime only.

Database View
Maintance View
Help View
Project View

Database view: Multiple tables are joined in this view.

Project View: One particular Table fields are used(few fields).

1. Views: view is a collection or combination or mixture of data dictionary tables view definition will not be available in database..

2. four types of views

a) database view
b) projection view
c) help view
d) maintenance view

3. Database view: combining two or more tables called database view projection view :an exact projection of a single table is called as a projection view.