Обсуждение: What changes to a table cannot be detected by a trigger?

Поиск
Список
Период
Сортировка

What changes to a table cannot be detected by a trigger?

От
Phillip Diffley
Дата:
Triggers can be set for insert, update, delete, and truncate operations. Alter table operations, like adding or dropping a column from a table, do not cause an update trigger to fire but can be captured by an event trigger.

Are there any situations where the data in a table can be changed and the change cannot be detected by a trigger or event trigger?

Thanks,
Phillip