Administer > Overview of administering a WebSphere Commerce site > Organization Administration Console > Organizations

Delete organizations

You can delete an organizations using two methods. Deleting an organization also deletes all of its descendant organizations, users, and assets (such as stores).

IBM recommends that you view each database table before deleting an organization to ensure that you are aware of what information will be deleted.

Procedure

• If you have created the organization in the Organization Administration Console, do the following in SQL:

  select orgentity_id from orgentity where orgentityname = 
  'Organization Short name' entered during creation
  delete from member where member_id = 
  orgentity_id from the previous query
  

• If you have created the organization using the Reseller Registration commands, there are primary and secondary database tables that have been populated. The MEMBER table is the database table that has primary information added. Secondary tables include the following information: MBRREL, MBRROLE, APRVSTATUS, USERREG, ADDRESS, and ADDRBOOK.

  To delete an organization, do the following in SQL:

  select users_id from userreg where logonId = 
  'User Name' entered during registration
  delete from member where member_id = 
  users_id from the previous query
  
  select orgentity_id from orgentity where orgentityname = 
  'Your organization name' entered during registration
  select mbrgrp_id from mbrgrp where owner_id = 
  orgentity_id from the previous query
  delete from member where member_id = 
  mbrgrp_id from the previous query
  delete from member where member_id = 
  same orgentity_id as above
    
  

Related concepts

Users

Member groups

Organization Administration Console

Related tasks

Changing organizations

Create an organization

+

Search Tips   |   Advanced Search