| Below is the query to get what structure has been change to table lastly with the simple query. Here we use sys object table
USE [DatabaseName]
GO
SELECT [TableName] = name,
create_date,
modify_date
FROM sys.tables
WHERE name = 'TransactionHistoryArchive'
GO | | |