table last modified date/time?

[Rob Wahmann]

I'm curious if there is a quick way to query the date/time a table was last
modified? I appreciate any tips or suggestions provided!

TIA - Rob

[Greg D. Moore \(Strider\)]

Re: table last modified date/time?


"Rob Wahmann" <rob@wahmann.co m> wrote in message
news:RekEb.1317 6$aw2.7122686@n ewssrv26.news.p rodigy.com...[color=blue]
> I'm curious if there is a quick way to query the date/time a table was[/color]
last[color=blue]
> modified? I appreciate any tips or suggestions provided![/color]

Not by default. One way is to have a timestamp column. Note, this is
simply an increasing number, not a real datetime.

The other is to have a trigger on updates/inserts that updates a Date Time
field.

[color=blue]
>
> TIA - Rob
>
>[/color]

[Rob Wahmann]

Re: table last modified date/time?

Ahh... thanks for the feedback. Just making sure there wasn't something
built in for that purpose. I'll set up a timestamp then. Thanks!!!

Rob

"Greg D. Moore (Strider)" <mooregr@greenm s.com> wrote in message
news:bRnEb.3024 9$JW3.21072@twi ster.nyroc.rr.c om...[color=blue]
>
> "Rob Wahmann" <rob@wahmann.co m> wrote in message
> news:RekEb.1317 6$aw2.7122686@n ewssrv26.news.p rodigy.com...[color=green]
> > I'm curious if there is a quick way to query the date/time a table was[/color]
> last[color=green]
> > modified? I appreciate any tips or suggestions provided![/color]
>
> Not by default. One way is to have a timestamp column. Note, this is
> simply an increasing number, not a real datetime.
>
> The other is to have a trigger on updates/inserts that updates a Date Time
> field.
>
>[color=green]
> >
> > TIA - Rob
> >
> >[/color]
>
>[/color]