How to drop multiple table from SQL when there is Sync Error
Issue:
Once we have restored the model store or just restored the DB we open AX AOT and started Sync, when in result gave 80 or 90 table errors.
Solution is to drop the those error table and start the sync all over again.
If its more then 5 or 6 like 80 or 100 tables showing errors, then use this command:
Drop Table Tablename
Drop Table Tablename
Drop Table Tablename and so on.
upto your table name list or
Drop Table Tablename1, Tablename2
Happy DAX infra!