What is the difference between SYNONYM and ALIAS?
Answer Posted / ss
YNONYM 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 is dropped.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is buffer pool and list some of them?
Outputs of explain are with matchcols = 0. What does this signify?
List some fields from sqlca?
What is null value in db2?
What is the difference between db2 and oracle?
How to fetch the last row from the table in SQL (db2)?
What is the usage of open cursor command?
Who uses db2?
What is precompiler in db2?
What is dbrm? When it will be created?
What is dclgen in db2?
How do I delete a column in db2?
What is the maximum length of sqlca?
What is db2 instance?
Explain about rct in db2?