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 / s

Synonym is alternate name for a table.

Use of synonyms avoids changes to programs when you migrate
programs from test to production.

create synonym abc for test.abc in test

create synonym abc for prod.abc in production

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get the ddl of a table in db2?

1091


What are foreign keys in db2?

1055


Why select is not preferred in embedded sql programs?

1252


What is db2 catalog database?

999


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2682


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

1053


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

985


What is sqlca?

1015


How to find schema of a table in db2?

975


is it compulsory commitment control in journal?

2438


What are the various data types available in db2?

1030


What is release/acquire in bind?

1074


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2040


What db2 400?

1118


How can you classify the locks in db2?

1045