Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13032 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 bind package and plan in db2?
What does reorg do in db2?
How is deadlock resolved?
What are the uses of db2 optimizer?
Can we delete records from view?
What does db2 stand for?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is the difference between spufi and qmf?
How to rename a table in DB2 ?
What is cursor in dbms?
What is db2 instance?
What is schema in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How do you eliminate duplicate values in db2?
What is role in db2?
