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 type of database is db2?
How is the value function used?
What is the use of reorg in db2?
What is innodb buffer pool?
Who uses db2?
List out the data types available.
What is view db2?
Outputs of explain are with matchcols = 0. What does this signify?
What is temporal table in db2?
How do I optimize a query in db2?
Where can you declare a cursor in a cobol-db2 program?
What does reorg do in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How to retrieve rows from a db2 table in embedded sql?
Can we delete records from view?