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
-- 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;
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
Here is what I did:
is working on a reply...
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