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 reorg and runstats in db2?
What is the difference between db2 and oracle?
What is explain plan in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What types of tables are there in the db2 database?
Is ibm db2 open source?
Explain the benefits you can get from mainframe connect?
Which components manage deadlocks in db2?
What parameters are used to control the free space in DB2?
What is the use of value function?
What is coalesce in db2?
Mention the definition of cobol in varchar field.
What is the difference between oracle and db2?
What is cursor with hold option in db2?
How to check sequence on a table in db2?