Sign in Register
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
    Copy Link
  • Nick Hoang 52 posts 182 karma points c-trib
    20 days ago
    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;
    Copy Link

  • 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" link below.

Please Sign in or register to post replies