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
Explain the benefits you can get from mainframe connect?
what is a corelated subquerry?
How to run db2 command in windows?
How can you classify the locks in db2?
Which command is used to remove all rows from a table?
What is the maximum size of varchar data type in db2?
Is db2 free?
How will you return the number of records in table?
What is the use of predicate?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How to compare data between two tables in db2?
What parameters are used to control the free space in DB2?
Discuss about db2 bind?
Is schema the same as database?
How can we retrieve the total number of records in RPG & CLLE?