What is an alias and how does it differ from a synonym?
- 3 Answers
- 11778 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
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What does runstats do in db2?
What is db2 instance?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the difference between cursor and select statement?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Explain various types of locks in db2?
What is null in db2?
What is the maximum No of rows per page?
What are catalog tables in db2?
Which component is responsible for processing sql statements and selecting access paths?
Explain package in db2 and its advantages?
How do you select a row using indexes in db2?
What is clone table?
What is cascading rollback?
