can i create trigger on synonym is it possible or not please help me

Answer Posted / shailesh

Yes, the trigger can be created on synonym. However, this trigger gets created on the respective base table for which the synonym is created.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is left join same as join?

514


What is gpt format?

498


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

563


What are the advantages of pl sql?

595


What is auto increment?

577






What are the benefits of pl sql?

521


What are functions in sql?

500


what is msql? : Sql dba

559


Which data dictionary views have the information on the triggers that are available in the database?

749


Why is partition used in sql?

542


What is dml statement?

513


Is it possible to link two groups inside a cross products after the cross products group has been created?

587


How does sql profiler work?

564


What are the differences between in and exists clause?

560


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

640