Delete full or partial data from MDS entity
I have started Microsoft MDS (Master Data Services) as a new category to share some really quick and helpful solution of problems faced while working. Let me know if you have Questions in comments section.
To delete partial (good number of rows) or full Entity data with MDS database, Manual UI usage is slow and really bad if numbers of rows are good enough.
Use following query and read the comments
/* . . . */ to see where you can update, based on your situation to get things done.
Posted on April 26, 2018, in Current, MDS, SQL and tagged Delete data from mdm table, delete data mdm with WHERE, Delete data with WHERE clause in MDS entity', Delete Full data from mdm table in MDS, Delete Partial data from mdm table MDS, Master Data Services, MDS, MDS entity, MDS entity delete data, Truncate Partial Data in MDS. Bookmark the permalink. Leave a comment.