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

If you update in store procedure it will not effort in synonyms.

If we delete the store procedure that synonyms will not
delete but it won’t work.

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dense_rank in sql?

1036


What is the difference between view and stored procedure?

999


What is left join in postgresql?

1090


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1140


Which sql statement is used to delete data from a database?

1005


How to know the last executed procedure?

1156


Is pl sql a scripting language?

1082


What are the various levels of constraints?

1167


Does postgresql run on the cloud?

1222


What are the different operators available in sql?

1057


What are the main features of cursor?

1108


difference between anonymous blocks and sub-programs.

1188


how does a local variable is defined using t-sql? : Transact sql

1058


Why is %isopen always false for an implicit cursor?

1151


what is primary key? : Sql dba

1076