3479916 - Is there any way to update "sysiqtable.update_time" only when a table is updated by DDL ? - SAP IQ

You want to know the last time when a table is changed by DDL only by using following query statement.

select U.user_name, T1.table_name , T2.create_time, T2.update_time
from systable T1, sysuser U, sysiqtable T2,
where U.user_id = T1.creator and T1.table_id= T2.table_id and T1.creator=<user_id>

However, "sysiqtable.update_time" column is updated when there is any change by both DDL and DML.

• SAP IQ 16.x 

KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To