Posted on

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!

Leave a Reply

Your email address will not be published. Required fields are marked *