CODEWITHSUNDEEP
t-sqlsybasesap-ase
KentZhou
KentZhou

Reputation: 25573

how to create a select trigger for sybase ase 12.5?

trigger usually is on delete, update, insert. It means update data. I want to a trigger for access data. for example, when applying select on a table, then a trigger can be fired.

Is it possible to create a trigger on select for sybase ase 12.5?

Upvotes: 0

Views: 484

Answers (1)

Robert
Robert

Reputation: 25753

This is trigger's statement from documentation:

create trigger [owner .]trigger_name
    on [owner .]table_name
    for {insert , update , delete} 
    as SQL_statements

as you can see, there is no option for select. So it's not possible.

Upvotes: 1

Related Questions