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

YNONYM and ALIAS are alternate names to a table. A SYNONYM
is dropped when the table is dropped whereas an alias is
not dropped if the table it is defined is dropped.

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 buffer pool and list some of them?

1046


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

1065


List some fields from sqlca?

1065


What is null value in db2?

1032


What is the difference between db2 and oracle?

1137


How to fetch the last row from the table in SQL (db2)?

1661


What is the usage of open cursor command?

1108


Who uses db2?

1059


What is precompiler in db2?

1026


What is dbrm? When it will be created?

1039


What is dclgen in db2?

1156


How do I delete a column in db2?

1115


What is the maximum length of sqlca?

1535


What is db2 instance?

1110


Explain about rct in db2?

1116