What is a synonym? How is it used?

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


Please Help Members By Posting Answers For Below Questions

Mention data types used in db2 ?

665


B37 abend during spufi?

975


What is role in db2?

610


What is a db2 package?

595


What is the role of the data page in the db2 database?

581






SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10728


What is clone table?

587


What is the purpose of rollback and commit?

589


What is cascading rollback?

615


How would the varchar column remarks defined?

626


what is diffrence b/w file-aid tool and file-aid utility???

4168


Is db2 a mainframe database?

559


What is null value in db2?

557


My sql statement select avg(salary) from emp yields inaccurate results. Why?

637


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

734