What is an alias and how does it differ from a synonym?
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
What is collection in db2 bind?
What is meant by explain?
When reorg is used?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is a db2 collection?
Which component is responsible for processing sql statements and selecting access paths?
What is difference between alias and synonym in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is commit in db2?
How to get the ddl of a table in db2?
What is coalesce in db2?
Which command is used to remove all rows from a table?
What is db2?
What is query_cache_limit?
what is the responsibility of the construction superintendent