Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mark Roffey 31 posts 184 karma points
    Apr 28, 2021 @ 15:06
    Mark Roffey
    0

    Delete all members via SQL script?

    Has anyone available a SQLscript that deletes all members from a database.

    I've found a few older V7 versions and obviously there are packages out there, but I'm looking to delete them via SQL Script so that I can incorporate it in as part of a deployment package.

    From what I can see the data is in the following tables. Can anyone confirm?

    cmsMember,

    cmsContentNu,

    umbracoNode,

    cmsMember2MemberGroup

    SELECT        cmsMember.nodeId, cmsMember.Email, cmsMember.LoginName, cmsMember.Password, cmsContentNu.nodeId AS Expr1, cmsContentNu.published, cmsContentNu.data, cmsContentNu.rv, umbracoNode.nodeObjectType, 
                             cmsMember2MemberGroup.MemberGroup
    FROM            cmsMember LEFT OUTER JOIN
                             cmsMember2MemberGroup ON cmsMember.nodeId = cmsMember2MemberGroup.Member LEFT OUTER JOIN
                             umbracoNode ON cmsMember.nodeId = umbracoNode.id LEFT OUTER JOIN
                             cmsContentNu ON cmsMember.nodeId = cmsContentNu.nodeId
    
  • Nick Hoang 52 posts 182 karma points c-trib
    Feb 27, 2025 @ 01:39
    Nick Hoang
    1

    Here is what I did:

    -- Step 1: Delete related records from cmsMember2MemberGroup
    DELETE FROM cmsMember2MemberGroup
    WHERE Member IN (SELECT nodeId FROM cmsMember);
    
    -- Step 2: Delete related records from cmsContentNu
    DELETE FROM cmsContentNu
    WHERE nodeId IN (SELECT nodeId FROM cmsMember);
    
    -- Step 3: Delete all records from cmsMember
    DELETE FROM cmsMember;
    
  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" button below.

    Continue discussion

Please Sign in or register to post replies