The following table describes DBMS support for triggers:
|
DBMS |
Table Triggers |
View Triggers |
Database Triggers |
|
DB2 for i |
No |
No |
|
|
DB2 LUW |
No |
||
|
DB2 z/OS |
No |
||
|
Informix |
No |
||
|
MySQL |
No |
No |
|
|
ODBC/Generic |
No |
No |
|
|
Oracle |
|||
|
PostgreSQL |
No |
||
|
Progress |
No |
No |
|
|
SAS |
No |
No |
|
|
SQL Server |
|||
|
SQL Azure |
|
|
|
|
SAP ASE |
No |
||
|
SAP IQ |
No |
No |
|
|
Teradata |
No |
No |
Additionally, DB2 LUW and DB2 z/OS support materialized query table triggers, SQL Server 2008 support server triggers, and Oracle supports materialized view triggers.
|
Copyright © 2017 erwin Inc.
All rights reserved.
|
|