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

explain the storage models of olap? : Sql server database administration

957

What methods do you follow to protect from sql injection attack?

1023

What is user-defined inline table-valued function?

946

Do you know what are the restrictions that views have to follow?

1077

What is the use of =,==,=== operators?

1009

What is checkpoint in sql server?

1147

How to Insert multiple rows with a single insert statement?

1054

what is nonclustered index

956

How to select some specific columns from a table in a query in ms sql server?

1003

What is difference between materialized view and view?

913

What is default constraint in ms sql server?

1033

What is exporting utility?

1019

What is federation member?

116

What is the impact on other user sessions when creating indexes?

922

What is a raid and what are different types of raid configurations?

1265