how to display last modified record from sqlserver table?

Last record update for all tables in the database ,

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( DBName')
AND OBJECT_ID=OBJECT_ID('test')

For table structure modification ,

select [name],create_date,modify_date from sys.tables
WHERE create_date <> modify_date ORDER BY modify_Date

Please mark as answer , if it helps you.