Deleting 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).

Task info

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

If you are deleting an organization from a staging environment, see Staging environment limitations.

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