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
asked 25 Oct '13, 11:08
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.
answered 25 Oct '13, 11:11