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 the difference between SYNONYM and ALIAS?

Answer Posted / nandivardhanreddy.n

when the table is dropped automatically synonym is dropped
and it is a private variable.
when the table is dropped alias is not dropped because it
is invalid and it is global variable.
synonym can accesed by the user who creates it

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the benefits you can get from mainframe connect?

970


what is a corelated subquerry?

1120


How to run db2 command in windows?

1191


How can you classify the locks in db2?

1088


Which command is used to remove all rows from a table?

1105


What is the maximum size of varchar data type in db2?

1131


Is db2 free?

1092


How will you return the number of records in table?

933


What is the use of predicate?

1039


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2065


How to compare data between two tables in db2?

1083


What parameters are used to control the free space in DB2?

1055


Discuss about db2 bind?

1091


Is schema the same as database?

1053


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

651