What is the difference between SYNONYM and ALIAS?
Answer Posted / s
SYNONYM and ALIAS are alternate names to a table. A SYNONYM
is dropped when the table is dropped whereas an alias is
not dropped if the table it is defined on is not dropped.
| Is This Answer Correct ? | 26 Yes | 17 No |
Post New Answer View All Answers
What is buffer pool?
What happens in bind step in a db2 program?
How can you do the explain of a dynamic sql statement?
What is performance tuning db2?
What is the connection string to connect to the DB2 Database ?
What does reorg do in db2?
What is ibm db2 client?
What is dbrm? What it contains? When it will be created?
How would you find out the total number of rows in a db2 table?
What is explain in db2?
Explain about dbrm.
How do you eliminate duplicate values in db2?
What is database reorganization?
What parameters are used to control the free space in DB2?
What are the two types of logging in the db2 database? Explain them.