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...

create a store procedure and created synonms for that store
procedure after modify that store procedure will effect on
synonms?
If we delete the store procedure what happened to that synonms?

Answer Posted / ankush

A synonym is an alternative name for objects such as
tables, views, sequences, stored procedures, and other
database objects.

So naming convention dose not effect the object if the
object code is update or modify.


The synonym exists in the datbase but it is in a invalid
state.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the best free sql database?

996


Is pl sql better than sql?

972


Does user triggers have entry for trigger with compilation errors?

972


How many subqueries can be nested in a statement?

927


What is a system versioned table?

927


What is a left join?

884


What is the difference between microsoft access and sql server?

986


Does view store data in sql?

896


What is use of term?

1006


What is update query?

919


What is cursor in pl sql?

1049


What is procedure explain with example?

893


What is use of package in pl sql?

945


What is normalisation and its types?

952


Why function is used in sql?

877