topic View in Application Development and Automation Discussions

View

Former Member — Mon, 12 Mar 2007 13:13:02 GMT

what is the diff between table with view and without view?

Re: View

Former Member — Mon, 12 Mar 2007 13:16:44 GMT

A base table is a table that usually has a permanent memory representation and description.

A view table is a view of one or more existing tables. Parts of these tables are hidden, and others remain visible.A view table has a permanent description in the form of a SELECT statement. View tables themselves contain no data, they only provide a view of the data.

for other details:

http://dev.mysql.com/doc/maxdb/en/fa/953c405865e801e10000000a155106/content.htm

regards,

madhu

Re: View

Former Member — Mon, 12 Mar 2007 13:17:23 GMT

Hi,

Table means a single table with fields.

View means more tables combined to a single one, You can write select statements for Views also.

Regards,

Anji

Re: View

Former Member — Mon, 12 Mar 2007 13:19:22 GMT

Hi...

View is nothing but a logical table.....

no data will be stored in a view.

when u retrieve data from a view it internally retrieves from the database tables only...

but depending on the requirement u need to create a view..

For ex:

if u have a table with 300 fields.. and u need only 10 fields among them in the present scenario..then we need to create a projection view for that table with those 10 fields..

there are 4 type of views:

These differ in the way in which the view is implemented and in the methods permitted for accessing the view data.

Database views are implemented with an equivalent view on the database.

Projection views are used to hide fields of a table (only projection).

Help views can be used as selection method in search helps.

Maintenance views permit you to maintain the data distributed on several tables for one application object at one time.