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 a user role in oracle?

1186

What are data pump export and import modes?

1112

Explain table?

1178

Explain the importance of .pll extension in oracle?

1061

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2170

How many types of auditing in Oracle?

1088

How to write a query with a right outer join in oracle?

1224

What is set verify off in oracle?

1160

6. Display the client name and order date for all orders using the traditional method.

2363

How to divide query output into groups in oracle?

1033

How to use like conditions in oracle?

1115

Why use resource manager in Oracle?

1174

What are transaction isolation levels supported by oracle?

1117

How view is different from a table?

1089

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1976