dbTalk Databases Forums  

Modified data for a table

comp.databases.sybase comp.databases.sybase


Discuss Modified data for a table in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Subind
 
Posts: n/a

Default Modified data for a table - 11-26-2009 , 01:04 AM






Hi,
How can I get the modified date for a table?

sp_help shows only Creation Date.

Thanks,
Subind

Reply With Quote
  #2  
Old   
Manish Negandhi [TeamSybase]
 
Posts: n/a

Default Re: Modified data for a table - 11-26-2009 , 01:39 AM






Looks like you what you want is date when table was last updated or
deleted. There is no such column in ASE , you can set up auditing to
audit each update and delete on any object

-HTH
Manish Negandhi
[TeamSybase]


On Nov 26, 12:04*pm, Subind <subind... (AT) gmail (DOT) com> wrote:
Quote:
Hi,
How can I get the modified date for a table?

sp_help shows only Creation Date.

Thanks,
Subind

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.