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

What is wrong with sql server client libarary dll, ntwdblib.dll?

1045

What are the different editions available in sql server 2000?

1056

What do you mean by a Composite primary key?

1110

What is db stored procedure?

883

What is difference between cte and view?

924

Explain what is log shipping?

1142

What is an index. What are the types?

1093

What is the difference between Stored Procedures and triggers?

1085

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1010

How to filter records of table in SQL SERVER?

1087

what are the core components of SSRS?

129

What is dynamic cursor in SQL SERVER?

1084

How to defragment table indexes?

998

What is sql server profiler?

1017

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113