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

What is deadlock in db2?

587


What is the clustering index in the db2 database?

586


How do I start db2 in windows?

567


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

655


What is a page in db2?

613






Define db2.

672


What does db2 blu stand for?

663


Mention the definition of cobol in varchar field.

700


How do I copy a table in db2?

576


How can record locking be achieved in those DB2 versions which do not support it?

627


What is table space in db2?

584


Name the various locking levels available?

638


How many types of page locks can be held in db2?

593


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

630


What's The Percentage Free Space ?

775