English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

2 answers

Table is the object which actually stores the data,
.
View are the object that can be created on one or more tables based on requirements . For view only definition is stored. So when you query a view you actually query the underlying table/s.

Ex.
Table A
View B-> select * from A;
Then Query
Select * from B will send to database as
Select * from A

2007-02-22 11:01:29 · answer #1 · answered by AAK 1 · 0 0

A base table is that - the actual table.

A view is a different way of looking at the base table. It could be that only a few columns of the base table are shown or it could be that they are manipulated it some way, or it could be that the view joins other tables to provide a complete set of data.

2007-02-22 17:14:25 · answer #2 · answered by BigRez 6 · 0 0

fedest.com, questions and answers