How to view the history of changes to database structures in MS SQL Server Management Studio?

Question

Microsoft SQL Server Management Studio

Hello. Some changes were made to the finished database (tables were created, columns were added, columns were deleted, keys and an index were created, etc.). You need to look at the history of these changes over a certain period of time. How can this be done in this program? Or is there no such possibility?

Answer 1

Of course, there is such a possibility. Make a trigger for changes, there are two steps:
1. Create a table where changes will be written.
2. create a trigger on the database.
In this case, I store: who, when, how it was, how it became, the date-time of the change.

Answer 2

MICROSOFT SQL SERVER MANAGEMENT STUDIO You need to look at the history of these changes over some period of time. How can this be done in this program? Or is there no such possibility?

No.
To track changes in the database structure , after the change, you need to make a complete "Create Database" script and feed it to any version control system.
There are third-party programs that can make a script difference between database versions.