I got it from net. Hope it will serve. select * from sys.dm_db_index

How to find the date and time of last updated table?

Question Posted / manish rathore

Answer Posted / manish rathore

I got it from net.
Hope it will serve.

select *
from sys.dm_db_index_usage_stats
where object_id = object_id( '<Table_Name>' )

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you store pictures in a database?

949

How to drop an index in oracle?

1018

Please explain oracle data types with examples?

990

if you ctreate table identity

2313

Explain constraining triggers.

1043

What is control file used for?

1098

What is redo log?

1004

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1849

How to select some columns from a table in oracle?

1003

How to create a single index for multiple columns?

977

What is a nested table and how is it different from a normal table?

985

What is the difference between "as" and "is" in an oracle stored procedure?

931

What is data block in Oracle?

1049

Explain about your project and its relation to the current job position you are applying to?

943

What is an index associated with a constraint?

973