Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13306 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 |
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Explain the function done by data manager?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is a cursor?
Comment whether the cursor is closed during commit or not.
How do you insert a record with a nullable column?
How would one remove old reorg information from the DB2 catalog?
What is a page?
What is a buffer pool?
What is clone table?
Can you define an Index if the table size less than 10 PAGES?
COBOL 
