Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to find when table last altered?

2 posts in General Discussion Last posting was on 2009-12-10 16:41:48.0Z
Nishant Rupani Posted on 2009-12-10 06:32:39.0Z
From: Nishant Rupani <>
Newsgroups: sybase.public.ase.general
Subject: How to find when table last altered?
Date: Wed, 9 Dec 2009 22:32:39 -0800 (PST)
Lines: 6
Message-ID: <>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: 1260426759 22948 (10 Dec 2009 06:32:39 GMT)
NNTP-Posting-Date: Thu, 10 Dec 2009 06:32:39 +0000 (UTC)
Injection-Info:; posting-host=; posting-account=y-Y-8QoAAABzR4Wr8eYwc4ZkHK7jRXT_
User-Agent: G2/1.0
X-HTTP-Via: 1.1 tiipx1:8080 (DataReactor/4.1.0p24d2), 1.1 tiipx2:8080 (DataReactor/4.1.0p24d2)
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; MSBrowserIE7; Windows NT 5.1; msie6xpv1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; MS-RTC LM 8),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!!!!!!!!!!!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28748
Article PK: 77990

Hi All,

Can someone help me with a way to find out when a table last altered?


Carl Kayser Posted on 2009-12-10 16:41:48.0Z
From: "Carl Kayser" <>
Newsgroups: sybase.public.ase.general
References: <>
Subject: Re: How to find when table last altered?
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3598
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
Message-ID: <4b2124cc$1@forums-1-dub>
Date: 10 Dec 2009 08:41:48 -0800
X-Trace: forums-1-dub 1260463308 (10 Dec 2009 08:41:48 -0800)
X-Original-Trace: 10 Dec 2009 08:41:48 -0800,
X-Authenticated-User: ase1251
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28753
Article PK: 77995

"Nishant Rupani" <> wrote in message
> Hi All,
> Can someone help me with a way to find out when a table last altered?
> Regards,
> Nishant

Auditing is the only way that I know of. The information is limited with
respect to the details of the structural change. At least you will know who
and when.