Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 difference between alias and synonym in db2?

1140


How to check last update on table in db2?

1059


What is copy pending and check pending in db2?

1002


What's The Percentage Free Space ?

1224


What does a deadlock mean in DB2?

1166


Which component is used to execute the sql statements?

1096


Explain various types of locks in db2?

1147


What is the physical storage length of the data types date, time, and timestamp?

1086


Is db2 a mainframe?

1043


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1190


What is dbrm? When it will be created?

1028


How and when does the db2 enforces the unique key?

1083


What is dclgen (declaration generator)?

1057


What is reorg and runstats in db2?

1217


What is the advantage in De-normalizing tables in DB2?

1173