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 create backup table in db2?

1044


On which levels locks can be applied?

1062


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

1020


what is utility for parm lib

2311


What is buffer pool and list some of them?

984


What is the picture clause of null indicator variable?

1083


What is load utility in db2?

1132


How to find the number of rows in db2 tables?

998


How can you find out the # of rows updated after an update statement?

1053


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3147


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

11618


What is null indicator in cobol db2?

994


Are views updateable?

1070


Is ibm db2 free?

955


Comment whether the cursor is closed during commit or not.

1042