Skip to Content

Setting a version number to procedures and functions

Hello, all

I need to help the technical support department in my company to identify db objects, which require updating from the central location.

In order to do that I need some point of reference, either a version number or a last modified time stamp for each DB object.

Is there such a property for functions, procedures and triggers? Using comments is out of question, this property is already utilized.

I am using SQL Anywhere 16.

Thank you

Arcady

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 01, 2016 at 07:34 AM

    Hi Arcady,


    Can you confirm following KBA?


    2055683 - How to provide SAP Support with some details of a SQL Anywhere database using dbtsinfo


    Can this information help you?

    Thanks,

    Atsushi

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 01, 2016 at 02:44 PM

    We do record the creation time of objects but not when objects have been modified.

    Add comment
    10|10000 characters needed characters exceeded