would you please any experience member explain me what is the real scenario in real time you use views and triggers in project.

Question

Hi would you please any experience member explain me what is the real scenario in real time you use views and triggers in project. How often you use views and triggers as a programmer. thanks in advance arun

arun kumar · Answer

Hi thankyou very much for reply. Views are used in case of security reasons...but dont you use in your everyday programming while working on different projects . thanks in advance. Please explain atleast one situation where you use in your everyday programming. arun

Akkiraju Ivaturi · Answer

Views are used when the database needs more security and any of the database objects are not supposed to be accessed by developers. You can access data only using views. Mostly used in Financial companies since data is very important and any complex business companies would not give access to the developers. Triggers are used when you want to check some validity on a row or a table or if you want to perform some action instead of some other action (instead of triggers) or to validate any changes to database. Mostly constraints are useful when compared to triggers.