How to find the date and time of last updated table?
Answer Posted / manoj
select table_name from user_tables where last_analyzed in
(select max(last_analyzed) from user_tables)
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is use of @@ spid in sql server?
Can you explain different types of locks in sql server?
explain the storage models of olap? : Sql server database administration
How to send email from database?
How many replicas are maintained for each sql azure db?
Does partitioning help performance?
Is sql server a database?
How do you debug a procedure in sql server?
What is scheduled job and how to create it?
Explain boyce and codd normal form(bcnf)?
List all types of constraints in sql server?
How to enter unicode character string literals in ms sql server?
How to use group functions in the select clause in ms sql server?
State a few properties of relational databases?
What are scalar functions in sql?