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
- 7567 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 %rowtype in pl sql?
What is a temporal data type?
How do I copy a table in sql?
what are aggregate and scalar functions? : Sql dba
What is trigger types in sql?
What is optimistic concurrency control? : Transact sql
Why do we need sharding?
What is a Mapplet?
what is cross join? : Sql dba
What is a join query?
what is the difference between a local and a global temporary table? : Sql dba
How many tables can a sql database have?
How can I get the number of records affected by a stored procedure?
Why use stored procedures?
how to get help information from the server? : Sql dba
