Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13119 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you pull up a query which was previously saved in qmf?
What does db2 plan contain?
Define declaration generator (dclgen).
How can you classify the locks in db2?
What is catalog database in db2?
What is the role of data manager in the db2 database?
What kind of database is db2?
What is a bind card?
What is syscat in db2?
What is db2 optimizer?
what is the role of the cursor in db2?
What is meant by explain?
Is ibm db2 open source?
Discuss about db2 bind?
List out the data types available.
