Symptom
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.
Read more...
Environment
- SAP IQ 16.x
Product
SAP IQ 16.0 ; SAP IQ 16.1
Keywords
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.