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.
Azure SQL Database – How to Track Table Schema Changes
azure-sql-databasesql server
Related Question
- Sql-server – Cannot restore azure database to local due to missing master key
- Sql-server – deploy data from sql 2016 backup to azure database
- Azure SQL – FK Relationships Between Schemas Not Working
- Migrate azure sql database to Azure SQL Database Managed Instance
- Azure SQL Database – dedicated administrator connection (DAC)
Best Answer
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.