Not logged in - Login

Remove Umbraco Nodes from DB



declare @ids table(id int)
insert into @ids 
SELECT [id]      
  FROM .[umbracoNode]
  where [YOU QUERY HERE]


DELETE FROM umbracoRelation
      WHERE [childId]  in (select id from @ids)

DELETE FROM cmsPreviewXml
      WHERE [nodeId]  in (select id from @ids)

DELETE FROM cmsContentVersion
      WHERE [ContentId]  in (select id from @ids)

DELETE FROM [cmsContent]
      WHERE [nodeId]  in (select id from @ids)

DELETE FROM [cmsPropertyData]
      WHERE [contentNodeId] in (select id from @ids)

DELETE FROM [cmsDocument]
      WHERE [nodeId] in (select id from @ids)

DELETE FROM cmsContentVersion WHERE [contentId] in (select id from @ids)

DELETE FROM cmsContentXml WHERE [nodeId] in (select id from @ids)

DELETE FROM umbracoRelation WHERE [parentId] in (select id from @ids)

DELETE FROM [umbracoNode]
  WHERE [id] in (select id from @ids)