uhateoas
6/6/2016 - 12:10 PM

Delete all members using SQL

Delete all members using SQL

delete from cmspropertydata where cmsPropertyData.contentNodeId in (select nodeid from cmsMember)
delete from dbo.cmsContentVersion where ContentId in (select nodeId from cmsMember)
delete from dbo.cmsMember2MemberGroup where member in (select nodeId from cmsMember)
delete from cmsContentXml where nodeId in (select nodeId from cmsMember)
delete from cmsPreviewXml where nodeId in (select nodeId from cmsMember)
create table #CmsMemberIds ( nodeId int )
insert into #CmsMemberIds select nodeId from cmsMember
delete from cmsMember
delete from cmsContent where nodeId in (select nodeid from #CmsMemberIds)
delete from dbo.umbracoNode where id in (select nodeId from #CmsMemberIds)
drop table #CmsMemberIds