Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13172 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 I start db2 in windows?
Which is faster delete or truncate?
What is plan in cobol db2?
How do I copy a table in db2?
What is the reason behind not using select * in embedded sql programs?
What is the use of db2 optimizer?
Explain about cursor stability?
Mention the downsides of page level lock.
What are host variables in db2?
What is db2 plan table?
Why do we need reorg in db2?
What is the physical storage length of date data type?
Explain the contents that are a part of dclgen.
What is db2? Explain.
What is host variable?
