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 |
No |
No |
|
|
Oracle |
|||
|
Progress |
No |
No |
|
|
SAS |
No |
No |
|
|
SQL Server 2000 |
No |
No |
|
|
SQL Server 2005 |
|||
|
SQL Server 2008 |
|||
|
Sybase |
No |
||
|
Sybase IQ |
No |
No |
|
|
Teradata |
No |
No |
Additionally, DB2 LUW and DB2 z/OS support materialized query table triggers, SQL Server 2005 and 2008 support server triggers, and Oracle supports materialized view triggers.
|
Copyright © 2013 CA.
All rights reserved.
|
|