Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13203 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guru
Alias & Synonyms are alternate of table or a view.
ALIAS SYNONYM
1. it is a global object. 1. it is aprivate object.
2. any one can access the 2. but the one who create
alias. the alias can only
access it.
3.when the base table is
droped.Alias is not dropped. 3. when the base table is
droped.SYNONYM is dropped
automatically.
| Is This Answer Correct ? | 19 Yes | 3 No |
Answer / krishna kant kumar
Alias is used in present session only but synonym is used in next session also because it is a database object.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
what is the difference between normal select query and currosor
wht happens if we close cursor with cursor with hold option?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
Explain the contention situations caused by locks?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
Give the name of some fields form sqlca.
How to get Top 10 Salaries from a Table
How do you prepare a COBOL + DB2 program from coading till execution ?
How do you retrieve the data from a nullable column?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is the FREE command?
Are views updateable?
COBOL 
