Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13167 Views
- I also Faced
- E-Mail Answers
Answer Posted / yogendra shinde
Hi,
Alias and Synonym both are alternative names to a table
name. But the major difference between Alias and Synonym is
that
>>>Alias can be used to refer a table at different location
( meaning different or remote system and it is not provate
to user who has created it)
>>> Synonym is used to refer table in the same location
with different name. Synonym is very much provate to the
user who has created it.
>>> Regarding dropping ALIAS and SYNONYM I am doubtful.
I have read that if we drop base table or base view then
both alias and synonym are also dropped (As per C.J.DATE
DB2 version 4.0). Please update if anybody has more on this.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
What is with ur in db2?
How do I import data from excel to db2?
Explain packages.
What is netezza database?
What is a trigger in the db2 database?
What are the different types of base tables?
What are the contents of dclgen?
Which isolation level provides highest data integrity?
Name the lockable units in DB2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What are the various isolation levels possible?
How can the duplicate values be eliminated from db2 select?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the advantage in De-normalizing tables in DB2?
What are the prerogatives?
