How to find when was table Last Truncated in Sybase? Any system table containing that Info

Question

Hi All Sybase Experts And Coders,

I have a strange requirement to find out when my Tables in database was last truncated? Is there any way to find out using any of the systemtables in sybase.

If Answer to above is No, then any solution to implement this? Since we have triggeres in DML statement level not sure will those come in handy in case of Truncate to log this execution time.

I'm using Sybase 15.7 version.

Any help is Highly Appreciated.

Cheers, Prashant

Answer 1

You have to implement database auditing in ASE.

Here is also an example of querying the audit data.