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

Define db2.

845


What is check constraint. Explain with example.

823


what is db2 restart?

1884


What is the physical storage length of date data type?

959


What do you mean by commit and rollback?

760






what is utility for parm lib

2083


What is dbrm? What it contains? When it will be created?

772


What is the use of db2?

771


What is the reason behind not using select * in embedded sql programs?

818


What is cloudant database?

819


What is dbrm?

843


What is the use of runstats in db2?

768


How can we retrieve the total number of records in RPG & CLLE?

354


What is the difference between cursor and select statement?

816


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

945