select table_name, to_char(last_analyzed, 'DD-MM-YY HH:MI:SS') f

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

Question Posted / manoj

Answer Posted / manoj

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Describe in brief sql server monitoring ways.

1095

What is the importance of concurrency control?

1271

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1104

How does recursive cte works in sql server?

1059

What is the difference between index seek vs. Index scan?

1062

What are the advantages to use stored procedures?

1177

Is sql server difficult to learn?

966

What languages bi uses to achieve the goal?

1050

explain what is raid and what are different types of raid configurations? : Sql server database administration

1049

what is the difference between Tabular and Matrix report?

179

Name 3 ways to get an accurate count of the number of records in a table?

1085

How to find which stored procedure is currently running in sql server?

1041

What specific conditions database should meet, before you can bulk copy data into it using bcp?

1038

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1317

What are the disadvantages of indexes?

1151