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

How to add the custom code in Report?

117

What are orphan records?

886

What are the essential components of sql server service broker?

965

Explain about merge replications?

964

What do you understand by triggers?

859

What are the limitations in ssrs on sql server express edition?

175

What is importing utility?

933

What is openxml in sql server?

1110

What is sql server database?

936

Define model database?

933

Explain about nested stored procedure?

976

What is pessimistic concurrency?

922

What is partitioned view?

853

What is a result set object returned by mssql_query()?

1070

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

181