Answer Posted / vinod
A synonym is used to reference a table or view by another
name. The other name can then be written in the application
code pointing to test tables in the development stage and to
production entities when the code is migrated. The synonym
is linked to the AUTHID that created it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between alias and synonym in db2?
How to check last update on table in db2?
What is copy pending and check pending in db2?
What's The Percentage Free Space ?
What does a deadlock mean in DB2?
Which component is used to execute the sql statements?
Explain various types of locks in db2?
What is the physical storage length of the data types date, time, and timestamp?
Is db2 a mainframe?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is dbrm? When it will be created?
How and when does the db2 enforces the unique key?
What is dclgen (declaration generator)?
What is reorg and runstats in db2?
What is the advantage in De-normalizing tables in DB2?