View previous topic :: View next topic
|
Author |
Message |
pjnithin
Active User
Joined: 22 Dec 2005 Posts: 116
|
|
|
|
Why do we use Aliases and Synonyms in DB2??? |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
Back to top |
|
|
pjnithin
Active User
Joined: 22 Dec 2005 Posts: 116
|
|
|
|
Those links doesn't give you a clear idea.
Could you please explain the actual use of it. |
|
Back to top |
|
|
Ranjanapai
New User
Joined: 21 Mar 2007 Posts: 3 Location: India
|
|
|
|
Aliases and synonyms are alternate names given the data base object. Using these will ease programming because since we are not hardcoding the table names with full qualifiers in the query, it becomes simple to use the code in different regions like testing, development production etc...
Synonyms can be created only on existing objects and they get deleted when the object is deleted.
alias can b created even if the object is not available and remains even if the object is deleted.
Hope this helps... |
|
Back to top |
|
|
|