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

What type of database is db2?

971


How is the value function used?

1157


What is the use of reorg in db2?

1086


What is innodb buffer pool?

1059


Who uses db2?

1050


List out the data types available.

1153


What is view db2?

1076


Outputs of explain are with matchcols = 0. What does this signify?

1060


What is temporal table in db2?

1041


How do I optimize a query in db2?

1101


Where can you declare a cursor in a cobol-db2 program?

1077


What does reorg do in db2?

1030


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

11675


How to retrieve rows from a db2 table in embedded sql?

1393


Can we delete records from view?

967