create a store procedure and created synonms for that store procedure after mod

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?

Question Posted / shivainduja

2 Answers
6563 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

create a store procedure and created synonms for that store procedure after modify that store proce..

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

create a store procedure and created synonms for that store procedure after modify that store proce..

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