Triggers on Views

Database
Enthusiast

Triggers on Views

Hello everybody!

In the "Teradata SQL Data Definition Language" book, I read that it is not possible to create triggers on data views. I wanted to ask, whether it is also true for the teradata versions 14 and 15?

Thank you!

2 REPLIES
Enthusiast

Re: Triggers on Views

You can see from the materials of 14& 15:

from 14 I see this:

The object referenced by table_name cannot be any of the following:

• global temporary table

• hash index

• join index

• recursive view

• queue table

• trace table

• volatile table

• view

Junior Supporter

Re: Triggers on Views

Hi.

There is no INSTEAD OF TRIGGER functionality in Teradata.

Oracle is Oracle, Teradata is Teradata.

Cheers.

Carlos.