Abstract
Triggers are objects that run when data changes (or in some cases, schema changes). They can run against tables or views and can be, well, triggered by inserts, updates, or deletes. There are some caveats on using them against a view (besides my personal opinion, which is: please don’t).
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Lisa Bohm
About this chapter
Cite this chapter
Bohm, L. (2020). Triggers. In: Refactoring Legacy T-SQL for Improved Performance. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5581-0_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5581-0_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5580-3
Online ISBN: 978-1-4842-5581-0
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)