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
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How do you check sql server is up and running?
How to test a dml trigger in ms sql server?
What is the Main Difference between ACCESS and SQL SERVER?
How to replace null values in expressions using isnull()?
How do I install only the client tools of sql server 2000?
What is normalization? What number of normalization shapes are there?
Mention the differences between local and global temporary tables.
What is postgresql server?
Differentiate between delete and truncate.
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is difference between line feed ( ) and carriage return ( )?
what are the reporting service components in SSRS?
Difference between drill down and drill through report.
How is table type constraint applied to a table?