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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is a sql*loader control file?
what is a unique key ? : Sql dba
How show all rows in sql?
Why indexing is needed?
What are three advantages to using sql?
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
what is a constraint? : Sql dba
How to get employee name from employee table which is the fiveth highest salary of the table
What is normalization? How many normalization forms are there?
Is microsoft sql free?
define join and explain different type of joins? : Sql dba
What is the use of prepared statement?