Azure sql database how to track table schema change So someone dropped a column in a Azure sql db. How to show the table schema before the change? Restore to a previous version is not a option as that would override everything.
You should had enabled Azure SQL Auditing.
Here you can find all about it.
https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview#subheading-1
Now you have to restore the database as a new database with an alternative name and the examine te differences in table definition.