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 is db2 command?

1091


What is the connection string to connect to the DB2 Database ?

1172


List down the types of triggers in the db2 database?

1079


What is query_cache_limit?

1034


How to connect to db2 database from windows command line?

1135


Name the lockable units in DB2?

1187


Can you tell me how can you find out the # of rows updated after an update statement?

1144


What is dclgen in db2?

1195


what is the sqlcode -501

13306


What are db2 tables?

1164


If I have a view which is a join of two or more tables, can this view be updateable?

1184


What are the various isolation levels possible?

1178


What is null indicator in cobol db2?

1109


What is the physical storage length of time data type?

1175


What is a db2 tablespace?

1118