Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias and how does it differ from a synonym?
- 3 Answers
- 13031 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
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is coalesce in db2?
Why do we use cursor?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What types of tables are there in the db2 database?
What is netezza database?
What is page size in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Why cursor is used in db2?
What's The Error Code For Unique Index Voilation?
What is the syntax for FETCH in DB2 ?
What is an instance database?
What is the connection string to connect to the DB2 Database ?
What is dbrm? What it contains?
What is consistency token in db2?
