topic Re: STURTURE in Application Development and Automation Discussions

STURTURE

Former Member — Mon, 24 Mar 2008 11:12:10 GMT

Hi all

What is the difference between a structure and a table?

vijay

Re: STURTURE

Former Member — Mon, 24 Mar 2008 11:13:29 GMT

hi,

structure will not occupy any space in database.but table will occupy space in database.

u can save data in tables only not in structures.

rgds,

bharat.

Re: STURTURE

Former Member — Mon, 24 Mar 2008 11:13:59 GMT

Hi,

Structure : Will not hold any data, at run time it will contain only one record.

Table : Will contain data.

Thanks,

Sriram POnna.

Re: STURTURE

Former Member — Mon, 24 Mar 2008 11:16:32 GMT

Hi,

Check this thread.

Regards,

Ramya

Re: STURTURE

Former Member — Mon, 24 Mar 2008 11:16:42 GMT

Table :

can hold data.

Structures:

Cant hold data.

used for manipulations in internal tables where there is no table reference.

Re: STURTURE

Former Member — Mon, 24 Mar 2008 11:20:17 GMT

Hi vijay, structure similar to tha table, stucture only exists as a definition in dictionery, not available in underlying database management, so it doesn`t contain any data. we can add few fields in structure and add to the table by using append structure or include structure.

Re: STURTURE

Former Member — Mon, 24 Mar 2008 11:20:43 GMT

srtructure does not require any memory

where as table requires it.

always table will have some data,structure will not have,

structure will be activated(working ) in run time.

reward if usefull

mngowda

Re: STURTURE

Former Member — Mon, 24 Mar 2008 11:22:19 GMT

Structure : Will not hold any data, at run time it will contain only one record.

Table : Will contain data and having database table associated with it.

Pls reward if help.

Regards

Deepanker

Re: STURTURE

Former Member — Mon, 24 Mar 2008 11:22:57 GMT

Hi,

Table: is a 2D data matrix containing rows and columns. Rows contain data while column indicates fields. Table can contain 0 or multiple rows.

Structure: is a skeletal view of a table. It contains the definition of columns and don’t have any contents. Structure is generally a template based on which a table is created. The basic difference between structure and table is that the structure does not exist at the underlying database system level. Structure exists as definition in the dictionary.

Regards,

Bhaskar

Re: STURTURE

Former Member — Mon, 24 Mar 2008 12:44:58 GMT

Structure : Will not hold any data, at run time it will contain only one record.

Table : Will contain data and having database table associated with it.

Pls reward if help.

Regards

Deepanker