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

Do you know what is openxml in sql server?

1015

What is the difference between the 2 operating modes of database mirroring?

1053

What is the benefit of normalization?

1018

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

135

Indexes are updated automatically is the full-text index also updated automatically?

971

How to deploy the Report?

125

Can we install sql server 2016 on windows 7?

1069

How to retrieve error messages using mssql_get_last_message()?

987

What are magic tables in sql server?

1067

if no size is defined while creating the database, what size will the database have? : Sql server administration

930

please differentiate between delete and truncate?

937

What is scan table/view and seek table/view when its occurs? : sql server database administration

983

If any stored procedure is encrypted, then can we see its definition in activity monitor?

933

Can a cursor be updated? If yes, how you can protect which columns are updated?

1027

whats the maximum size of view state??

2146