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?
- 2 Answers
- 7000 Views
- Polaris, I also Faced
- E-Mail Answers
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
How do I truncate a sql log file?
Why truncate is used in sql?
Explain how exception handling is done in advance pl/sql?
What sql does db2 use?
Why triggers are used?
What is cost in sql execution plan?
What is clause in sql?
What are the types of keys?
What is a join query?
How do I partition a table in sql?
How do I install microsoft sql?
Is it important to partition hard disk?
Is join and inner join the same?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is scalar function in sql?
