You can undo changes you've made to a database that aren't committed to source control yet.
The most common types of change SQL Source Control can't undo are:
You can only use SQL Source Control to undo changes you haven't committed.
To undo changes that have been committed, use SQL Server Management Studio Integration Pack to update the database to a specific version, or use your source control system.
You can't undo a data link or a data edit.
To stop source-controlling a table's data, right-click it in the object explorer and click Link/Unlink Static Data. In the Link/Unlink Static Data dialog box, you can choose to stop source controlling the table's data.
If you drop a table or column that contained data, the data isn't restored when you undo the drop.
If you drop a NOT NULL column from a table that contained data, undoing the drop will fail if the column doesn't have a default value.