Post reply

Altered Date and Time Of Table

  • March 10, 2006 at 5:16 am

    #111437

    Hai Everybody,

    I want to get the Last Altered Date and Time of the Table.

    and

    also want to know how to get the Last Updated Date and Time of Table(That means Date and Time of Last Operation(Insert or Update Or Delete).

     

    Thanks......

     

     

  • March 10, 2006 at 6:54 am

    #625933

    Does your table have those columns? Are you saving that data anywhere?

    When a transaction happens on the database, a date/time isn't recorded unless you create a trigger or some other way to record that information.

    -SQLBill

  • March 12, 2006 at 8:02 pm

    #626158

    Thanks for your Confirmation.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply