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

What is where clause in oracle?

1031

Where is the export dump file located?

1159

What are the different types of modules in oracle forms?

1001

Use of an integrity constraint is better to validate data. Explain

1043

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1053

How can we delete duplicate rows in a table?

976

What is not equal to in oracle?

1003

What is oracle datasource?

993

Explain the difference between replace() and translate() functions in oracle?

1040

Difference between pre-select and pre-query

1115

What is background process in Oracle?

1105

What is meant by joins?

1062

What is a directory object?

1099

Explain joins in oracle?

1038

What is a dynamic performance view in oracle?

994