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?
- 2 Answers
- 7586 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
What are the types of subqueries?
How to add a column ‘salary’ to a table employee_details?
What does count (*) do in sql?
What is t sql used for?
How will you distinguish a global variable with a local variable in pl/sql?
What is %s in sql?
What is data modelling in sql?
What are operators available in sql?
Why is stored procedure faster than query?
How to rename a table?
What is schema in sql?
What is recursive join in sql?
what are ddl statements in mysql? : Sql dba
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
How do I copy a table in sql?
