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
- 7469 Views
- Polaris, I also Faced
- E-Mail Answers
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 |
Can 2 queries be executed simultaneously in a distributed database system?
How do I remove sql developer from windows 10?
What are reports usually used for?
What is the use of index in hive?
What is a native sql query?
How do I start sql profiler?
What is the difference between an inner join and an outer join?
what is myisam? : Sql dba
What is a sql trace file?
Is drop table faster than truncate?
What is Data Concarency and Consistency?
Is the primary key an index?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
