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
What is the best free sql database?
Is pl sql better than sql?
Does user triggers have entry for trigger with compilation errors?
How many subqueries can be nested in a statement?
What is a system versioned table?
What is a left join?
What is the difference between microsoft access and sql server?
Does view store data in sql?
What is use of term?
What is update query?
What is cursor in pl sql?
What is procedure explain with example?
What is use of package in pl sql?
What is normalisation and its types?
Why function is used in sql?