Table Modified/Updated Details

Scripts to find when Last transactions are done in a table:

SELECT
      last_user_update
FROM
      sys.dm_db_index_usage_stats
WHERE
      object_id=object_id('TableName')

Scripts to find when the table's Schema are changed last:

SELECT
      name as Table_Name,
      [modify_date]
FROM
      sys.tables