view

[former_member222933]

what are the differance between structure and view?

[Former Member · Accepted solution]

Structure: It is defined as a group of components. A component can refer to an elementary type (via a data element or by directly specifying the data type and length in the structure definition), another structure or a table type. A structure can therefore be nested to any depth.. It is just a defination and cannot contain any data.

View It is a virtual or logical table composed of the result set of a query. Unlike ordinary transperant tables it never has nay physical schema. They can subset the data contained in a table or they can join and simplify multiple tables into a single virtual table. Views can also act as aggregated tables, where aggregated data (sum, average etc.) are calculated and presented as part of the data.

[Former Member]

Hi Sai

<b>Structure :</b> It is created during runtime..and storage of data is temporary.

<b>Views :</b> These are virtual tables which contains data from different tables by using join condition

Reward all helpfull answers

Regards

Pavan

[Former Member]

Hi Kadam,

Check this thread "Diff between structure and view":

Regards,

Subhasha