SAP Knowledge Base Article - Preview

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 


SAP IQ 16.0 ; SAP IQ 16.1


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.