difference btn synonym, alias ,views

sankari_thiyaga · New User Joined: 14 May 2005 Posts: 4

hi,
could u plz explain me the difference btn synonym,alias,views.
Of these three which do occupy memory space?
which can be deleted?
sankari.

brain_s390 · New User Joined: 06 May 2005 Posts: 58 Location: Mumbai

Synonym : It is an unqualified alternative name for a table or view.

VIEW : It is a virtual table made up of data from base tables and other views, but not stored separately.

ALIAS : An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.

Hope above clarifies !!

i413678 · Posted: Mon May 16, 2005 5:27 pm

Hi,

Alias and synanyms are alternate names for DB2 objects with the following differences.

Synonym:
1. this is the local object only user has to create and access it.
2.used in local environment.
3.when base table is dropped automatically synonyms are dropped.
4.SYSADM authority is not needed.

Alias:
1. this is the global object.
2.used in distributed environment.
3.when base table is dropped aliases not dropped.
4.SYSADM authority is needed to create this or CREATEALIAS previlege is needed.

View:
View is part of the table(s).

pavan

sankari_thiyaga · New User Joined: 14 May 2005 Posts: 4

thank u ,i'm clarified.
sankari.