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
- 7543 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 dcl in sql?
How many types of triggers are there in pl sql?
What are sql queries used for?
what are the differences between require and include, include_once and require_once? : Sql dba
What is file based approach?
how tsql statements can be written and submitted to the database engine? : Transact sql
what are the types of join and explain each? : Sql dba
What is the difference between microsoft sql and mysql?
How do I find duplicates in the same column?
Why do we use cursors?
Which are sql * plus commands?
What is sql partition function?
List and explain the different types of join clauses supported in ansi-standard sql?
How to read xml file in oracle pl sql?
how would you enter characters as hex numbers? : Sql dba
