HANA Triggers

[Former Member]

I was wondering if it would be possible to have a trigger that whenever a row is inserted or updated in Table A, it automatically creates another row in the history table with that same data as in table A, except with one additional column which is a sequence? Any help on this would be appreciated. How would the SQL script to create this look?

Thanks,

Connor

[Former Member]

Hello,

There is a CREATE TRIGGER statement. Here you can find more details with examples:

https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/d5a65575191014946db96aaedbef5b/content.htm

Hope this helps.

Lukasz