SQL Refreshment Contest 9

[vjsreevs]

What is the difference between view and table

Both are data base objects but
View restrict data access ,used for presenting different vies of same data to different people .
Table is mainly used for storing data but it cant restrict data access.

[vjsreevs]

tats a nice try unreg ... nymore elaborative xplanations ???

table:- Basic storage unit ; composed of rows and columns

View:- logically represents the subset of data from one or more tables

[mohit_singhal]

in view same thing can be show in different manners to diff. diff. people.
but it is not possible in the case of table.

Table is a database object where all the information can be stored in the form of rows and columns while view is a virtual table which does not contain any data of its own,its a window to the table data from where only selective information can be seen.

[ajithcharles]

Further explaining what Namita said, Whenever a view is accessed, the query used to create view is executed and the changes in the base data tables are reflected.

[ajithcharles]

Just for information sake, Adding to Views we also have materialized views, these are views which can store information juz like temporary tables. Materialized views unlike Views contain Data in them.