It is a virtual table..
A view in SQL terminology is a single table that is derived from other tables.
These other tables can be base tables or previously defined views.
A view does not necessarily exist in physical form. it is considered to be a virtual table.
Base tables: whose tables are always physically stored in the database.
Why are we need views?
A table that we need to reference frequently, even though it may not exist physically.
No comments:
Post a Comment