What is the difference between SYNONYM and ALIAS?
Answer Posted / nandivardhanreddy.n
when the table is dropped automatically synonym is dropped
and it is a private variable.
when the table is dropped alias is not dropped because it
is invalid and it is global variable.
synonym can accesed by the user who creates it
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is db2 command?
What is the connection string to connect to the DB2 Database ?
List down the types of triggers in the db2 database?
What is query_cache_limit?
How to connect to db2 database from windows command line?
Name the lockable units in DB2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is dclgen in db2?
what is the sqlcode -501
What are db2 tables?
If I have a view which is a join of two or more tables, can this view be updateable?
What are the various isolation levels possible?
What is null indicator in cobol db2?
What is the physical storage length of time data type?
What is a db2 tablespace?