Created
September 2, 2014 19:35
-
-
Save eerrecart/c85732c41d14932b53d1 to your computer and use it in GitHub Desktop.
Umbraco - Delete Umbraco nodes by Document Type Alias
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BEGIN TRAN | |
DECLARE @Nodes TABLE (NodeId int) | |
INSERT INTO @Nodes (NodeId) | |
SELECT top 1000 n.id | |
FROM cmsContent C | |
INNER JOIN cmsContentType CT ON C.contentType = CT.nodeId | |
INNER JOIN umbracoNode N ON C.nodeId = N.id | |
WHERE CT.alias = '[Your Document Type Alias Here]' | |
select id, [text] from umbracoNode where id in (select NodeId from @Nodes) | |
delete from cmsPreviewXml where nodeId in (select NodeId from @Nodes) | |
delete from cmsContentVersion where contentId in (select NodeId from @Nodes) | |
delete from cmsDocument where nodeId in (select NodeId from @Nodes) | |
delete from cmsContentXML where nodeId in (select NodeId from @Nodes) | |
delete from cmsContent where nodeId in (select NodeId from @Nodes) | |
delete from cmsPropertyData where contentNodeId in (select NodeId from @Nodes) | |
delete from umbracoRelation where parentId in (select NodeId from @Nodes) OR childId in (select NodeId from @Nodes) | |
delete from cmsTagRelationship where nodeId in (select NodeId from @Nodes) | |
delete from umbracoNode where id in (select NodeId from @Nodes) | |
DELETE FROM @Nodes | |
ROLLBACK TRAN |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment