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
- 7669 Views
- Polaris, I also Faced
- E-Mail Answers
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 procedure and function in sql?
How do you update a table in sql?
What are the different types of a subquery?
how is myisam table stored? : Sql dba
What is schema in sql example?
Is coalesce faster than isnull?
How to use sql statements in pl/sql?
How do I partition a table in sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is sql clause?
What is trigger with example?
Explain some predefined exceptions.
Can you load data into multiple tables at once? : aql loader
what is rollback? : Sql dba
what is self join and what is the requirement of self join? : Sql dba
