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 release/acquire in bind?

1164


What is sqlca?

1133


Define predicate?

1204


Why do we use cursor?

1164


What do you mean by cursor?

1036


How does a cursor work?

1043


What is a db2 cursor?

1110


How do you simulate the explain of an embedded sql statement in spufi/qmf?

1144


How do I import a csv file into db2?

1041


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1147


What is check constraint. Explain with example.

1163


What is drop table?

1071


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

1096


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1218


What is netezza database?

1082