How to find the date and time of last updated table?
Answers were Sorted based on User's Feedback
Answer / monal
USE TRIGGER OR ADD DATETIMESTAMP COLUMN IN A TABLE WITH
DEFAULT VALUE OF GETDATE()
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / sanjeev kumar
SELECT OBJECT_NAME(OBJECT_ID) AS tablename,
last_user_update
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'your_database_name')
and user_updates>0
order by last_user_seek desc
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / smitha
select name,create_date,modify_date from sys.tables
order by modify_date desc
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / vidit tyagi
SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName,
last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'DataBaseName')
AND OBJECT_ID=OBJECT_ID('TableName')
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ram
USE TRIGGER OR ADD DATETIMESTAMP COLUMN IN A TABLE WITH
DEFAULT VALUE OF GETDATE()
Is This Answer Correct ? | 1 Yes | 1 No |
select scn_to_timestamp(max(ora_rowscn)) from <TN>
Is This Answer Correct ? | 0 Yes | 0 No |
Disadvantages of the indexes?
Describe triggers features and limitations?
How to delete a database in ms sql server?
Is index a datbase objects in sql server?
What is executereader?
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
What are different types of statement?
what is the difference between Delete and Truncate
4 Answers CarrizalSoft Technologies, Geo Research Centre,
Why I am getting this error when dropping a database in ms sql server?
What is standby servers? Explain types of standby servers.
Explain different isolation levels?
what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?