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
- 7568 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 |
Types of joins ?
3 Answers Digital GlobalSoft, HeadStrong,
Can we commit in trigger?
define sql insert statement ? : Sql dba
what is a join? : Sql dba
How many row comparison operators are used while working with a subquery?
What is a primary key example?
what are all the different normalizations? : Sql dba
What is the best free sql database?
Does sql view stored data?
Why do we use cursors?
How do I create a sql database?
What is view? Can we update view
-
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)
