What are stored procedures, functions and triggers?
Model answer
Stored procedures and functions are reusable code stored in the database. Triggers run automatically on events such as insert or update. They can enforce rules close to the data but can hide logic and complicate testing and deployment, so use them thoughtfully.
Learn this topic
Indexes and Faster Queries: EXPLAIN for Beginners in the course SQL for Beginners: Learn Databases Step by Step.
Sign in to add your own answer.