The system catalogs store a creation date for a table, but do not store an alter date.
The column system catalog does not store date information. If there is a date
stored, I do not know where they would keep it.

Sorry.

Richard

On Wed, 29 Jan 2003 18:00:59 +0530, yogesh kansal wrote:

>Hi list ,
>How can get the last modified date of a table .
>I want to know exactly when a particular table was modified using ALTER TABLE command .
>any clues ??
>We are using DB2 7.2 on Linux .
>Thanks in advance .
>Yogesh
>
>
>Yogesh Kansal
>Davlin Software Pvt Ltd .
>2nd Floor , Punja Building,
>Lalbaugh , Mangalore
>Ph 0824-451001 ext - 19
>
>"For every problem there is always a solution that is simple, obvious, and wrong !! "
>
>
>
>
>
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] J Reppert
Sumx Inc.
972-355-8004 x102
972-355-8048 fax


DB2 & UDB email list listserv db2-l LazyDBA home page