Modified time for stored procedure in sybase IQ

[Former Member]

Hi,

In Sybase IQ, I want to query the modify date/time for store procedures. However, it seems that sybase IQ only has creation_time for the objects. Is there a way I can get modify_time for an object such as stored procedure??

select object_name(object_id),* from sys.SYSOBJECT where object_name(object_id) is not null and object_type='6' order by creation_time desc

[MarkCulp · Accepted solution]

SQL Anywhere (and IQ) does not keep track of the modification time of a schema object... so there is no method to get this information.