Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

STURTURE

Former Member
0 Likes
1,110

Hi all

What is the difference between a structure and a table?

vijay

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,062

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.

9 REPLIES 9
Read only

Former Member
0 Likes
1,063

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.

Read only

Former Member
0 Likes
1,062

Hi,

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

Table : Will contain data.

Thanks,

Sriram POnna.

Read only

Former Member
0 Likes
1,062

Hi,

Check this thread.

Regards,

Ramya

Read only

Former Member
0 Likes
1,062

Table :

can hold data.

Structures:

Cant hold data.

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

Read only

0 Likes
1,062

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

by

mngowda

Read only

Former Member
0 Likes
1,062

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.

Read only

Former Member
0 Likes
1,062

Hi

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

Read only

Former Member
0 Likes
1,062

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

Read only

Former Member
0 Likes
1,062

Hi

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