Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13303 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
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the use of dclgen in db2?
What is db2 optimizer?
What is coalesce in db2?
What is check constraint. Explain with example.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What are the two types of logging in the db2 database? Explain them.
What are the uses of db2 optimizer?
How to find schema of a table in db2?
What is a db2 cursor?
How to fetch the last row from the table in SQL (db2)?
What are the bind parameters ibm db2?
What is a trigger in the db2 database?
What is cursor with hold option in db2?
Why do chiropractors use drop table?
