Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13182 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 the use of db2?
What is host variable?
Explain the contention situations caused by locks?
What is db2?
What is the difference between nvl and coalesce?
What is db2 optimizer?
What is db2 purescale?
What is the function of logging in the db2 database?
What is runstats and reorg in db2?
What do you mean by cursor?
How can you do the explain of a dynamic sql statement?
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 default page size of buffer pools?
What are the uses of db2 optimizer?
How to connect to db2 database from windows command line?
