Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Are there any plans to implement INSTEAD OF triggers for views?
An INSTED OF trigger is code that is executed instead of an INSERT, DELETE or UPDATE statement.
This works for both tables and views.
Syntax:
CREATE TRIGGER [schema_name.] trigger_name
ON
INSTEAD OF
{[INSERT] [,] [UPDATE] [,] [DELETE] }AS
{sql_statements}You can find some documentation about this at:
https://www.sqlservertutorial.net/sql-server-triggers/sql-server-instead-of-trigger/
https://www.oracletutorial.com/plsql-tutorial/oracle-instead-of-triggers/
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Priority | Minor [ 4 ] | Major [ 3 ] |
| Workflow | MariaDB v3 [ 79781 ] | MariaDB v4 [ 130605 ] |
| Description | Are there any plans to implement INSTEAD OF triggers for views? |
Are there any plans to implement INSTEAD OF triggers for views?
An INSTED OF trigger is code that is executed instead of an INSERT, DELETE or UPDATE statement. This works for both tables and views. Syntax: CREATE TRIGGER [schema_name.] trigger_name ON {table_name | view_name } INSTEAD OF {[INSERT] [,] [UPDATE] [,] [DELETE] } AS {sql_statements} You can find some documentation about this at: https://www.sqlservertutorial.net/sql-server-triggers/sql-server-instead-of-trigger/ https://www.oracletutorial.com/plsql-tutorial/oracle-instead-of-triggers/ |