|
|
|
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 © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |