Announcements
No record found.
Hi Everyone,
Trying to do a tidy up the tables in Azure Synapse Analytics. There are a number of tables that I have Deactivated in Finance and Operations Export to Data Lake which still come through on Synapse. CDMutil doesn't seem to take them out and I can't drop the tables in Synapse, SSMS or Azure data Studio.
Dose anyone have any tips for removing deactivated tables from Synapse?
Hi,
Related question and discussions are found for you, please check them:
Azure Synapse Unable to drop created table - Microsoft Q&A
Drop Database Error For Azure Synapse Database - Stack Overflow
Hope these will be useful!
Best Regards,
Hana
This post is my own opinion and does not necessarily reflect the opinion or view of my company.
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Thanks Hana,
Yea had read those before, not exactly what I'm after.
My main thing here is how are others dealing with deactivating tables in Finance and Operations then cleaning up their Data Lake and Synapse so they don't have lots of orphaned tables per se.
Can't seem to find a lot written on the subject....
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 620
André Arnaud de Cal... 521 Super User 2026 Season 1
CP04-islander 430
