Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13187 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 can you do the explain of a dynamic sql statement?
How do I import a csv file into db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is a db2 schema?
What are db2 objects?
What is the syntax for FETCH in DB2 ?
What are host variables in db2?
How to take backup of table in db2?
What is the use of db2?
Comment whether the cursor is closed during commit or not.
What is the difference between oracle and db2?
What is a buffer in memory?
What is the latest version of ibm db2?
What are the prerogatives?
Is db2 a mainframe database?
