You can view history for databases linked to Git, SVN or TFS.
To view history for other source control systems, use your source control client's history feature.
To view the revision history of a database or database object, in the Object Explorer, right-click the database or object and click View history:
The History dialog box opens:
The History dialog box shows:
You can use the History dialog box to get a specific version of the database.
If you're on a branch, the History dialog will show the history for that branch only.
You can change the number of revisions shown in the History dialog box by editing a config file. If the History dialog box is slow to load, limiting the number of revisions shown might speed it up. For more information, see Change how many revisions are shown in the History dialog box.