Append Structure Vs Include Structure + Help View

[Former Member]

Hi Experts,

1/ Please tell me the difference between these two way of modifying table.

Which one is useful when ?

2/ What is Help View and how it is different from Other Views(Database,Projection,Maintainance) ?

Regards

Sonal

[Former Member]

Hi,

Append structure : it will add Fields to the table from

last . we can't use that structure in another table.

Include structure: we can add fields to the table but we can

use include structure in more than one table.

If you have to select data from several tables for the search help, you should generally use a database view as selection method. However, a database view always implements an inner join. If you need a view with outer join for the data selection, you have to use a help view as selection method.

if useful reward points...

Edited by: subas Bose on May 18, 2008 8:46 AM

[Former Member]

APPEND STRUCTURE .

1)IT CAN ONLY BE

APPENDED AT THE

LAST

2)IT IS NOT REUSABLE

IT CAN BE USED ONLY

IN ONE TABLE

3)IF U WANT TO

DELETE THE APPEND

STRUCTURE DELETE

THE ENTIRE TABLE

INCLUDE STRUCTURE

1)IT CAN ONLY BE

INCLUDED ANYWHERE IN

THE TABLE

2)IT IS REUSABLE

IT CAN BE USED

IN MORE THAN ONE TABLE

3)ONLY THE INCLUDE STRUCTURE

CAN BE DELETED WITHOUT

DELETING THE TABLE

You have to create a help view if a view with outer join is needed as selection method of a search help.

The selection method of a search help is either a table or a view. If you have to select data from several tables for the search help, you should generally use a database view as selection method. However, a database view always implements an inner join. If you need a view with outer join for the data selection, you have to use a help view as selection method.

Edited by: moazam hai on May 18, 2008 9:27 AM