What is an alias and how does it differ from a synonym?
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 difference between bind and rebind in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How do I copy a table in db2?
What is bind in db2?
Define check constraint.
Explain in brief how does db2 determine what lock-size to use?
How would you find out the total number of rows in a db2 table?
How to find the number of rows in db2 tables?
Is it possible using max on a char column?
When do you specify the isolation level?
What is query_cache_limit?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the use of db2?
Who uses db2?
What is null indicator in cobol db2?